Hi there,
I would like to Scan the Region column and rank the Revenue column, only
if the Region matches 'SK'. Right now it ranks based on the entire list
a1:a9....I want it to only rank on the number of entries equal to region
'SK'
Any suggestions?
Thanks
Tim
A B C
1 Region Revenue Rank
2 SK 2,500
3 North-AB 3,000
4 SK 3,300
5 South-AB 1,985
6 North-AB 1,650
7 SK 2,300