| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
functions largest to smallest
I am looking for a function that will arrange a group of cells from largest
to smallest. This formula has to be within my worksheet. I need to show 1st place, 2nd place, 3rd place, etc. After the program calculates the scores it then needs to show who won these places and the name of winners. Can someone help me with this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
functions largest to smallest
On the assumption all the scores are in a single column on the worksheet why
don't you simply sort the data by that column. "Sevengails" wrote: I am looking for a function that will arrange a group of cells from largest to smallest. This formula has to be within my worksheet. I need to show 1st place, 2nd place, 3rd place, etc. After the program calculates the scores it then needs to show who won these places and the name of winners. Can someone help me with this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
functions largest to smallest
If this is not what you want, look at Rank in help.
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "Mike" wrote in message ... On the assumption all the scores are in a single column on the worksheet why don't you simply sort the data by that column. "Sevengails" wrote: I am looking for a function that will arrange a group of cells from largest to smallest. This formula has to be within my worksheet. I need to show 1st place, 2nd place, 3rd place, etc. After the program calculates the scores it then needs to show who won these places and the name of winners. Can someone help me with this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I calculate a statistical range (largest minus smallest)? | Excel Discussion (Misc queries) | |||
| Identifing smallest numbers | Excel Discussion (Misc queries) | |||
| COMPARE DATA AND LIST SMALLEST AND LARGEST ENTRY BY UNIT | Excel Discussion (Misc queries) | |||
| Getting the 2nd largest or smallest valuesin a range | Excel Discussion (Misc queries) | |||
| Ranking cells largest to smallest | Excel Discussion (Misc queries) | |||
Linear Mode
