Return the highest and 2nd highest value

J. Angel

Hello,

I need a formula which will return the highest and 2nd highest value. For the table below, it would need to return "Wednesday" as the highest and "Tuesday" as #2.

Paul Newcome

You are going to want to use the LARGE function inside of a nested IF statement.

=IF(Saturday@row = LARGE(Saturday@row:Friday@row, 1), "Saturday", IF(Sunday@row = LARGE(Saturday@row:Friday@row, 1), "Sunday", IF(Monday@row = LARGE(Saturday@row:Friday@row, 1), "Monday", ....................

To get the second highest you would change the 1 in the LARGE function to a 2.