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
 
Back
Top