Hello all,
right i have a standard table which has a list of names in alphabetical order what i want is basically like a high alert table that will drag out the top 5 results from the original table. any ideas?
Ricky
Hello all,
right i have a standard table which has a list of names in alphabetical order what i want is basically like a high alert table that will drag out the top 5 results from the original table. any ideas?
Ricky
How are your data? Column A=Names and Column B=Numbers?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
a1 name - b1 total errors -c1 times assisted - d1 total amount assisted
Try.
In E1 and copy down for 4 rows.
=LARGE($D$1:$D$100;ROWS($1:1))
Use the below for highest values in Column B and adapt for other columns accordingly
=LARGE(B:B,1) for the highest result
=LARGE(B:B,2) for the next highest
=LARGE(B:B,3) for the next ...and so on
Life's a spreadsheet, Excel!
Say thanks, Click *
this is good and brings up the right number but is there any way for it to bring up the name and number of who is top
Use the below in F1 to pick the name of the highest value which you've already calculated in E1 and drag below till E5 to get the highest 5 names in Rows 1-5 respectively
=INDEX($A:D,MATCH(E1,B:B,0),1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks