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
|