Excel Tricks with Tejraj

In this blog post we will learn to about TRANSPOSE function in excel. We can use TRANSPOSE function to convert vertical cell range into horizontal cell range and horizontal cell range into vertical cell range . Where to find TRANSPOSE function on Excel Screen: TRANSPOSE function can be found under “Lookup & Reference” function category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Lookup & Reference” function category, we can see list of various Lookup & Reference functions available in excel. TRANSPOSE function is highlighted in blue in below image. Once we click on TRANSPOSE option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of TRANSPOSE Function: The Syntax of TRANSPOSE function is as below: =TRANSPOSE(array) Arguments of TRANSPOSE Function: TRANSPOSE function takes only one argument. array : In this argument we have to select cell range which we want to conver...

In this blog post we will learn to about CHOOSE function in excel. CHOOSE function will choose a value or an action to perform based on the provided index number. Where to find CHOOSE function on Excel Screen: CHOOSE function can be found under “Lookup & Reference” function category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Lookup & Reference” function category, we can see list of various Lookup & Reference functions available in excel. CHOOSE function is highlighted in blue in below image. Once we click on CHOOSE option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of CHOOSE Function: The Syntax of CHOOSE function is as below: =CHOOSE(index_num, value1, [value2], …) Arguments of CHOOSE Function: CHOOSE function have below arguments. index_num : This argument decides which value argument is to be selected. We must provide number between 1 to 254. If we are providing...