All,

I have a multi criteria ranking formula (thanks soo much to all who helped me get that working I appreciate it sooo much)

=1+SUMPRODUCT(('DATA MERGE'!$D:$D=MODEL!R$5)*('DATA MERGE'!$I:$I>MODEL!K14))

This formula ranks the cost of a number of divisions and subdivisions
Division: Finance
Subdivision: Accounts
Cost: $20M

Ranks no. 4

This formula will bring back the number 4 ranking for 20m in a range of 10m - 60m

However, my boss now wants to bring back the 9th or 10th ranking! (instead of the divisions actual ranking - apparently this is logical who knows)

How do we ask excel to go through the rankings (with condition like division and subdivision) and bring back the 9th or 10th?

Thanks ever so much

Keelin