Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a scenario where I need to rank data according to size, top 3 and
bottom 3. A B C (Large) D 1 20 Car 1 20 - Car 2 15 Dog 2 15 - Dog 3 5 New 3 15 - Are 4 15 Are 5 10 Err Column A and B are my data, I use column C as reference in the Large and Small formula and then concatenate with D as the result. But my problem is when I have 2 similar result as in this example no.2 and 3. What should I do so that the 3rd highest is correctly reference? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Large and small values | Charts and Charting in Excel | |||
SMALL/LARGE and text | Excel Discussion (Misc queries) | |||
Charting small and large percentages | Charts and Charting in Excel | |||
Sorting numbers in a row from small to large | Excel Discussion (Misc queries) | |||
SMALL and LARGE | Excel Discussion (Misc queries) |