I wish to find the second and third highest values in each of the rows on the attached spreadsheet. Finding the highest is no problem using MAX. Also, if 2 values are the highest, I want one to count as the second highest value.
My ultimate goal is to calculate the average of the three highest values in each row. I wish to use formulas, as VB is beyond me.
Thanks
Last edited by jmhultin; 03-21-2011 at 06:36 PM.
Please look at Excel Help for the LARGE function.
Wow! Perfect - Thanks!
hi 6StringJazzer,
how can i get the row and column number of the retuned result.
Actually I have some data associated and kept in same row as the values. Now how can I apply the Large function??
AnkitGuru,
Welcome to the Forum.
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks