| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up formula?
BRILLIANT!!! Working perfectly! Thanks!
On Wednesday, December 2, 2015 at 8:45:38 PM UTC-5, zvkmpw wrote: I have a row of numbers (C2 - N2) that are assigned to names in row C4 to N4. I need to right a formula that will rank these 12 names by the highest number. So in column P4 - P15 I need the names to show from highest # in C4 to N4. P4 = the name with the highest #. P5 = the name with the 2nd highest # and so on. If the numbers are all different in every example, try this in P4 and copy down to P15: =HLOOKUP(LARGE($C$2:$N$2,ROW()-3),$C$2:$N$4,3,FALSE) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula autofill to cells below – formula arguments are cell areas in different columns | Excel Discussion (Misc queries) | |||
| Build formula using field values as text in the formula referencing another workbook | Links and Linking in Excel | |||
| Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
| Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Threaded Mode
