LinkBack URL
About LinkBacks
How to create a formula to get the average value of any two highest value from 3 cells (A1, B1, C1 & D1) and put it into cell E1? (problem: the 2 highest value can be in any of the 4 cells, not fixed)
Pls help.
Thank you very much.
How to create a formula to get the average value of any two highest value from 3 cells (A1, B1, C1 & D1) and put it into cell E1? (problem: the 2 highest value can be in any of the 4 cells, not fixed)
Pls help.
Thank you very much.
Try:
=AVERAGE(LARGE(A1:A4,{1,2}))
where A1:A4 is the range of cells to use...
EDIT: Removed instruction to confirm with CSE key combo. Formula is not an array formula and can be entered as is.
Last edited by NBVC; 11-14-2007 at 09:22 AM.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
You don't actually need CSE for that formula......
Dang it! I'm getting to used to array formulas....:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks