How to Fine Top 10 Customers

**shaileshgavanang** · 06-23-2012, 01:10 PM

Hi,

i have customer database xls.

i want to find out top 10 customers from the given data.

please help.

thank you,

**jeffreybrown** · 06-23-2012, 01:16 PM

You can use the rank function

=RANK(A2,$A$2:$A$100)

Data is in column A

or a pivot table

**shaileshgavanang** · 06-23-2012, 02:02 PM

Hi, Thanks for the solution.

but, i want highest 10 customer name from the given data.

sample xls attached.

thank you,

Originally Posted by jeffreybrown

You can use the rank function

=RANK(A2,$A$2:$A$100)

Data is in column A

or a pivot table

**Spencer101** · 06-23-2012, 02:10 PM

How about this approach?
It uses a helper column (A) to allocate unique rank numbers, then VLOOKUP to show the names in the lower table.

**jeffreybrown** · 06-23-2012, 09:29 PM

Hi shaileshgavanang,

In B25 copied down

=INDEX($A$9:$A$19,MATCH(LARGE($B$9:$B$19,A25),$B$9:$B$19,0))

**shaileshgavanang** · 06-24-2012, 12:59 PM

Hi All,

Thanks for help

Re: How to Fine Top 10 Customers