Not sure if my title makes sense...what I have is a list of data that shows how many customer surveys each staff member has received. I want to find the 5 employees who have received the most comments/surveys from customers. So, my top 5. I have that formula.
Column C
=LARGE(F3:F48,1)
=LARGE(F3:F48,2)
=LARGE(F3:F48,3)
=LARGE(F3:F48,4)
=LARGE(F3:F48,5)
F3:F48 = the range of who has how many surveys
In Column B I have the names of the coresponding numbers...
=INDEX($B$3:$B$48, MATCH(C61,$F$3:$F$48,0))
=INDEX($B$3:$B$48, MATCH(C62,$F$3:$F$48,0))
=INDEX($B$3:$B$48, MATCH(C63,$F$3:$F$48,0))
=INDEX($B$3:$B$48, MATCH(C64,$F$3:$F$48,0))
=INDEX($B$3:$B$48, MATCH(C65,$F$3:$F$48,0))
$B$3:$B$48 = the range of first names
C61 = the cell comparing
$F$3:$F$48 = the range of who has how many surveys
0 = not sure
Top Staff
#1 Matt 21
#2 Matt 21
#3 Eric 19
#4 Ermin 18
#5 Catherine 14
Currently this is my result. Matt and Phil have the same number, 21. But alphabetically it pulls Matt's name twice. How do I get it to skip Matt and put in Phil?
Bookmarks