Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Data from a different sheet
I have data that is ranked on one sheet and I would like to display the data
on another sheet in rank order. I.e, On one sheet I have team names followed by the rank. On the other sheet I would like to display the teams in rank order. I really cant think of a way to do this, my problem is that sometimes I have a situation where I have two firsts. I can't think away around it. I would also ideally like the list to auto update. Thank you. R. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Data from a different sheet
In source sheet say teams are in A2:A11, rank in B2:B11. In
destination enter the ranks (1, 2, 3...) in A2:A11. In B2: =INDEX(Sheet1!$A$2:$A$11,MATCH(A2,Sheet1!$B$2:$B$1 1,0)) HTH Kostis Vezerides On Nov 4, 6:37*pm, VoxBox-Richard wrote: I have data that is ranked on one sheet and I would like to display the data on another sheet in rank order. I.e, On one sheet I have team names followed by the rank. *On the other sheet I would like to display the teams in rank order. I really cant think of a way to do this, my problem is that sometimes I have a situation where I have two firsts. *I can't think away around it. I would also ideally like the list to auto update. Thank you. R. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting data from one sheet to another | Excel Discussion (Misc queries) | |||
sorting data from one sheet to another | Excel Worksheet Functions | |||
SORTING DATA TO ANOTHER SHEET | Excel Worksheet Functions | |||
SORTING DATA TO ANOTHER SHEET | Excel Worksheet Functions | |||
Sorting data in a master sheet | Excel Worksheet Functions |