Imagine five columns filled with numbers from 0-100. In the sixth column, I need to be able to calculate the average of the two highest numbers in the row.
For example:
A1 B1 C1 D1 E1 F1
56 86 29 89 23 87.5*
* This cell would show 87.5 as the result because the two highest numbers are 86 and 89 so the average is 87.5.
I have had a think about it but I can't think of a suitable way of doing it...can anyone help please?
Cheers!
Social Networking Bookmarks