One of the function which I do like is "TRANSPOSE" function. - This function copies data from a range, and places in it in a new range, turning it so that the data originally in columns is now in rows, and the data originally in rows is in columns.
- The transpose range must be the same size as the original range.
- The function needs to be entered as an array formula.
- To enter an array formula you must first highlight all the cells where the
formula is required. Next type the formula, such as *=TRANSPOSE(A1:A5)* and
Finally press *Ctrl+Shift+Enter* to confirm it.
If changes need to be made to the formula, the entire array has to
be highlighted, the edits can then be made and the Ctrl+Shift+Enter used to
confirm it.
*Syntax :-*
*=TRANSPOSE(Range)*
Regards,
Manoj Kumar
On Thu, Jan 13, 2011 at 11:15 PM, Ms-Exl-Learner . <ms.exl.lear...@gmail.com
> wrote:
> Hi All,
>
> I suggest all of you don't say this function I like and then this one like
> that. Just sharing the function name won't help others to gain some
> knowledge. All the functions which is available in excel is having the same
> set of qualities unless it is used in perfect combination.
>
> So give brief about the function and its different type of usages which you
> came across in your past.
>
> Hope this makes sense.
>
> -----------------------
> Ms.Exl.Learner
> -----------------------
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
TRANSPOSE FUNCTION_Manoj.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
