View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Equal ranks - but no gaps

It's late ...ignore my last reply!

"Thomas" wrote:

I checked quite a number of answers in this area, but couldn't find a
solution to my little ranking problem (column B is the ranking as I would
like to see it):

A B
1 Value Rank
2 1 1
3 1 1
4 1 1
5 2 2 <----- that being the 'tricky' part :)
6 3 3

Thank you very much!
Thomas