James Perry
Member
Hello Friends...here's something i want2 share with you.
Assume i have 100 rows of data - a simple data set of SalesReps in column A and $Sales in column B.
The Boss wants2 know the names of the SalesReps who made it to the "top ten" in terms of $Sales value.
To find the name of the SalesRep who figured among the top ten -
drag the following formula down to TEN rows.
=INDEX(A:A,MATCH(LARGE(B:B,ROW(A1)),B:B))
Assume i have 100 rows of data - a simple data set of SalesReps in column A and $Sales in column B.
The Boss wants2 know the names of the SalesReps who made it to the "top ten" in terms of $Sales value.
To find the name of the SalesRep who figured among the top ten -
drag the following formula down to TEN rows.
=INDEX(A:A,MATCH(LARGE(B:B,ROW(A1)),B:B))