I have a table in Excel with these values:
100 Tim
50 Rich
80 Fiona
95 Orion
I need functions to return the 2nd largest value. Therefore, in cell A5, I want to output the value 95. In cell A6, I want to output Orion using Excel functions. TIA!
I have a table in Excel with these values:
100 Tim
50 Rich
80 Fiona
95 Orion
I need functions to return the 2nd largest value. Therefore, in cell A5, I want to output the value 95. In cell A6, I want to output Orion using Excel functions. TIA!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks