Help with Sumproduct or Rank

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
 
J

Joel

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

Top