Help with Sumproduct or Rank

  • Thread starter Thread starter Kim
  • Start date Start date
K

Kim

I've this formula =SUMPRODUCT(($L$2:$L$35=L4)*(AO4<$AO$2:$AO$35))+1

1. It give me the correct ranking but from highest to lowest. I need them to
be lowest to the highest.

2. At the moment it gives me the ranking based on column L. If I need it to
give me the ranking based on 2 criteria (ie same country and same postal
city). Country= column C, Postal City = column L. This is because the same
postal city could be in two country. Ie Birmingham in UK and in US.

Thanks.
Kim
 
going from highest to lowest is simply changing the "<" to ">".


Here is the results for two cities

=SUMPRODUCT(($C$2:$C$35=C4)*($L$2:$L$35=L4)*(AO4>$AO$2:$AO$35))+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

Subtracting Values from a Ranked List 4
Tricky Ranking Question 1
Copy Unique Record 2
Ranking Without Skipping Ranks When a Tie Occurs 4
Rank based on 2 categories 6
Ranking Top 5 in score and percentage 1
Rank a list of proposals 3
Ranking Subgroups that are above 750 1

Back
Top