I am trying to use the following function to rank part of an array based on
one condition, but the function returns the rank for the entire array. Any
suggestions?

RANK(IF((Calls!$A$1:Calls!$A$1000=Calls!A100),Call s!B100),Calls!$B$1:$B$1000))

Thanks,

IP