Ranking within in ranges

G

Guest

I need a formula that will allow me to rank one column of numbers based on a
value in another column. e.g. If I have values in column A and countries in
column B. I want to rank the values by country in other words each country
will have a #1 etc. also the number of values by each country will be
different

thanks

ah
 
D

daddylonglegs

Assuming you have data in rows 2 to 100 use this formula in row 2 and
copy down

=SUMPRODUCT(--(A$2:A$100>A2),--(B$2:B$100=B2))+1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ranking Sales Reps 2
Counting values in column B in condition of A 2
Conditional Ranking 8
Ranking based on two columns 2
Vlookup using a dropdwn list, check different tables based on drop 2
Conditional sum, when condition has multiple values 3
Weighted average with changing weights… 1
Reverse ranking 1

Top