Rank by Certain Criteria

Hi,

I'm trying to find a formula that will rank data based on a certain criteria (rather than having to sort it and run a rank formula for each criteria manually). I have different territories, with a few hundred stores in each territory, and would like the rank formula to rank that value within its' particular territory. The table attached shows what the table looks like. It also needs to be a formula that is compatible with Excel 2003.

Book1.xls

Any ideas would be much appreciated.

Thanks!

Hi again

if you have same values in same territory you could use in order to get different rank numbers

=SUMPRODUCT(($C$2:$C$100=C2)*(B2<$B$2:$B$100))+SUMPRODUCT((C$2:C2=C2)*(B$2:B2=B2))

Regards