Formula to return the second highest value in a column

**kimi01** · 05-05-2022, 03:59 PM

Re the attached example.

How can I return the second highest value in column C? The number of values in that column will differ, hence the need for the formula.

Thanks

**FlameRetired** · 05-05-2022, 04:08 PM

Try this formula.

Formula:

Please Login or Register  to view this content.

**kimi01** · 05-05-2022, 04:15 PM

Thank you. Didn't know LARGE existed!

**FlameRetired** · 05-05-2022, 04:18 PM

You are welcome. Thank you for your feedback and marking this thread Solved.

Yes Excel is full of surprises like that.

Formula to return the second highest value in a column

LinkBack

Thread Tools

Rate This Thread

Display

Formula to return the second highest value in a column

Re: Formula to return the second highest value in a column

Re: Formula to return the second highest value in a column

Re: Formula to return the second highest value in a column

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula to return the highest number in a column based on a matching second column

Return a value from a column based on the highest number in the adjacent column

[SOLVED] Find top 5 highest values in row from every third column and return column header

Formula needed to return the name corresponding to the three highest values in column

[SOLVED] Max formula to return total of highest, second highest and third highest value

Return column of second highest value in row, where it is the same as the max value

[SOLVED] Formula to find lowest/highest value in a column and return value to that cell

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions