View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mbass mbass is offline
external usenet poster
 
Posts: 1
Default Rank using another column for tiebreaker

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?