Hi,
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. Please advise. Thanks.