|
|
#3
02-05-2010, 12:24 PM
|
|||
|
|||
Assuming the person's name is located next to the score (in column B), and the list is A1:A5 as above, you'll need to use a vlookup. First get the max score in a cell (formula : =max(A1:A5); put this cell in C1
Then use a vlookup, (formula : =vlookup(C1, A1:B5, 2, False) Thanks 
|
| Tags |
| conditional format |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Urgent help regarding automation.
|
aligahk06 | Excel | 1 | 01-14-2010 01:55 PM |
| Urgent Help Required | id12345 | Word | 4 | 12-29-2009 08:22 AM |
| Weird but urgent identity problem | Afterburn | Outlook | 0 | 12-10-2009 01:30 AM |
|
kindly fix my problem its urgent!
|
SyedaAdil | Office | 1 | 11-04-2009 08:15 AM |
| Urgent help! | captainspi | Word | 2 | 04-19-2009 11:17 AM |
Windows XP 
Office 2007
Threaded Mode