I am trying to find a function that will search a column of values and find the two greatest values. Even better, if the function could add those two values together to give the result I would be smiling!
Thanks
I am trying to find a function that will search a column of values and find the two greatest values. Even better, if the function could add those two values together to give the result I would be smiling!
Thanks
Try this...
Formula:Please Login or Register to view this content.
Change the column reference A:A to your desired Column
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
A simple way could be this.
=LARGE(A2:A10,1)+LARGE(A2:A10,2)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks Fotis1991 - does exactly what it says on the tin!
Solved - thanks people!
You are welcome and thanks for the feed back.
I have to say to you that also Sixthsense 's way works fine.
As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks