Ranking top 50 by market

[runner]

Is there a formula that will rank the top product sales from 1-50, 1 being the highest sales by market, I have a spreadsheet with the market name listed in column a, sales dollars in column e, product name in column c:

Market name is repeated for all sales dollars.

[Tony Valko]

Can you post a few examples and show us what results you expect?

[runner]

I have the rank formula in the spreadsheet attached, but I need a way to look at column A for each market, otherwise I would have to copy down every 50 rows to over 100k rows.

[Tony Valko]

Not sure what you're wanting to do with this.

[boopathiraja]

In B2 Apply the below and drag it down

Please Login or Register  to view this content.

[runner]

Boopathiraja, that formula worked, it considered the market name for the top 50 rank within each market, genius, thanks.