ST Alpha - "ST Excel Challenge: I need a formula that will return the second highest value in a range." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 159

ST Excel Challenge: I need a formula that will return the second highest value in a range.

Posted by psilotum Nov 19 '08, 11:29

Am I overlooking something obvious?

Responses:

=LARGE(A1:A100,2) -- nm - budice Nov 19, 11:31 2
- very cool! thanks. -- nm - psilotum Nov 19, 11:32
- Just found that. -- nm - VMan Nov 19, 11:32
=AVE(FRENCH JUDGE)A1:A99 -- nm - Max Nov 19, 11:31
I think you'd have to sort the data in a separate area and just take the second cell. -- nm - VMan Nov 19, 11:31 1
- This would work, but would also suck because the data changes frequently. -- nm - psilotum Nov 19, 11:32

Post a message top

Replies are disabled on threads older than 7 days.