hi
I have a spreadsheet which has numbers in columns which then make a total
is there a formula for discounting any one of the columns but still having a total eg
10 10 9 10 =30 as I only want the 3 highest numbers
Or is it just easier to do it manually bearing in mind that these cells already have numbers based on a formula
=ROUND(MIN(H:H)/H8*10000,0)
thanks for nay help[!
Bookmarks