| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
An Excel Formula know how to re-arrange the data
The 2 data sets are assumed running in A3 and in B3 down, viz.:
In A3 down is: A, B, C, D and E In B3 down is: 35, 45, 13, 8 and 3. The result which I want is to list the data E, D, C, A and B from the cell C3 to C7. I want a formula which know how to rank the data in which the Excel formula know B has the highest value of 45 and E has the lowest value of 3. Many thanks, Wilchong -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200805/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| re-arrange cell data | Excel Discussion (Misc queries) | |||
| How do I arrange a formula between cells that are not together? | Excel Worksheet Functions | |||
| how to split data into columns and arrange the resulting data | Excel Discussion (Misc queries) | |||
| Excel should let me change the form data arrange direction | Excel Worksheet Functions | |||
| arrange data by criteria | New Users to Excel | |||
Threaded Mode
