CODEWITHSUNDEEP
excel
ASM
ASM

Reputation: 363

Rank top N in excel

I have a table in excel that presents names and sales data, I would like to add additional column (rank) that will place a number of rank (5,10,25,Others) that means that if name A is in the top 5 it all have 5 in its rank column.

The goal of this calculation is to create a slicer that shows (5,10,25,Others) which will allow me to filter sales and names by rank.

  1. Is it possible to do it and how?
  2. Is there some other approach that will be more efficient?

Excel Table

Upvotes: 1

Views: 115

Answers (1)

Mertinc
Mertinc

Reputation: 781

Yes, It's possible and actually easy.

Type into C1 cell, (or The first cell of Rank column)

=RANK.EQ($B1,$B:$B,0)

And drag this formula till the end.

This one will sort the list in descending order. If you wish to get the rank numbers in ascending number change the 0 as 1.

Upvotes: 2

Related Questions