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

Using the "Large" function - "=Large( array, 2 )" will return the second
largest number in the array.

Regards,
Bill


"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