| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying winner/first four placings.
Using one of the two formulas below to display the name (in column B) of the
highest scorer (from column C) in another cell (B*) is it possible to modify either to display the highest four placings? How would I allow for a tied score. =OFFSET(C1,MATCH(MAX(C1:C10),$C$1:$C$10,0)-1,-1,1,1) or =INDEX(B:B,MATCH(MAX(C:C),C:C,0)) Regards TWK |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to display the winner | Excel Worksheet Functions | |||
| Can Excel randomly pick one winner out of 100 contest entries? | Excel Discussion (Misc queries) | |||
| Displaying a different value | Excel Discussion (Misc queries) | |||
| Formula for placings, using 4 times and greater than minimum time | Excel Worksheet Functions | |||
| Displaying #N/A as a zero | Excel Worksheet Functions | |||
Threaded Mode
