View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Excel Rookie Excel Rookie is offline
external usenet poster
 
Posts: 3
Default Listing top 3 numbers

Hello,
Need some advice on this one:

I've used the rank function to assess the top 3 numbers in a range of cells.
I'd like to enter a formula into a cell that lists the top 3 numbers.
Or if this is not possible, enter a formula into 3 cells:
Cell 1: Highest result
Cell 2: Second highest
Cell 3: Third Highest.

Thanks!
--
Excel Rookie