=1+SUMPRODUCT(--($B$1:$B$8<B1))+SUMPRODUCT(--($A$1:$A$8<A1),--($B$1:$B$8=B1))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"mbass" wrote in message
...
I am trying to figure out how to use another column as a tiebreaker when
using the rank feature. For example:



Column A Column B Rank

150 55 3

362 65 5

251 67 6

119 55 3

167 87 8

225 44 1

269 83 7

198 44 1



I want to rank Column B but if there is a tie, I want to look at column A
to
break that tie.



Can you help me?