Hi there
I have a spreadsheet and in there I have the following formula
This only gives the result of the first instance of a max. (In this particular line on my spreadsheet B33, C33 and D33 all contain the same max result.=INDEX($B$32:$F$32,0,MATCH(MAX($B33:$H33),$B33:$H33,0))
Is it possible to adapt the formula so that if there are multiple results of the same max, the formula will then add them all up and divide by how many there are.
At present it presents 0 as that is the first occurrence, however when there are more as below it finds ALL instances of the highest value (ie 2, it then adds up all the header values where it occurs, in example below 0, 1 and 2. It recognises there are 3 occurrences so would produce 0+1+2 = (3) / 3 lots, so 3/3 = 1.
So it would return 1 as the answer?
ie.
--Col-B---|--Col-C--|--Col-D-|--Col-E-|--Col-F--|
--Row32--|----0----|----1----|----2----|----3----|
--Row33--|----2----|----2----|----2----|----1----|
Bookmarks