Very simple problem. I need the second highest value in an array.
Max gives me highest.
Min gives me lowest.
I need a kind of a MAX2 function.
Any ideas?
Very simple problem. I need the second highest value in an array.
Max gives me highest.
Min gives me lowest.
I need a kind of a MAX2 function.
Any ideas?
Last edited by NBVC; 11-12-2008 at 06:03 PM.
Use the LARGE function...
=LARGE(Range,2)
Hope this helps!
Perfect!
I knew there had to be some trick.
I didn't know there was a function.
Thanks
You're very welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks