View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default How do you rank in order numbers from highest to the lowest?

If you don't want the duplicates ranked the same
=RANK(A2,A$2:A$10)+COUNTIF(A$2:A2,A2)-1


"Anika" wrote:

For Example

How would I rank these numbers in order from highest to the lowest

Current Points Current Place
46
48
44
44.5
48
44
44