Hi all,
I am trying to return the name of the top 5 salespeople for a given store. I have a working formula if all their sales came through on one line, however, they come through on multiple lines. So essentially, I want to sum the sales for each person, then rank them based on their total sales and group by location.
This formula returns a name, but only based on 1 line of sales - not the sum of all their sales.
{=INDEX($B2:$B21,MATCH(LARGE(IF($C$2:$C$21=$G$1,$D$2:$D$21),1),$D$2:$D$21,0))}
Bookmarks