Hello
I have a spread sheet with a column of names and scores
I Want a list of the the top ten score in a separate list, I have tried with a few ways but got lost with the formulas
Kind regards John
Hello
I have a spread sheet with a column of names and scores
I Want a list of the the top ten score in a separate list, I have tried with a few ways but got lost with the formulas
Kind regards John
in I3 copy down
=IF(ROWS($1:1) <=10,LARGE(Total,ROWS($1:1)),"")
Hello John
I want the names also in the top ten list with there scores.
Sorry for not explaining well
I thought you might !!!
In column N a Helper column to account for duplicate scores
=I3+(COUNTIFS($I$3:I3,I3)-1)*10^-3
In M
=INDEX(Names,MATCH(LARGE($N$3:$N$37,ROWS($1:1)),$N$3:$N$37,0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks