View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David A. David A. is offline
external usenet poster
 
Posts: 64
Default Ranking if number is 550

I need to know how to rank a list of numbers but only rank the numbers above
550.
Example
A
1523
1242
550
890

I need to rank 1523, 1242, 890, and leave 550 out...
So the ranking should be 1523:3, 1242:2, and 890:1
Thanx.