Add "1" to highest value from a range

[zudecke]

Hi guys,

Context: If I wanted a field that looked at a RANGE of other values and then added "1" to the highest value.

I.e. In a holiday booking example (just for illustration), if I felt more strongly about the room score than the spa score, I might want to add "1" to the highest scoring room option.

So I've attached a sample sheet. I want CELL O3 to consider the highest value in the "ROOM SCORE" column (COLUMN D) and then +1 to whichever value was the highest. Only the highest value should trigger a +1 in COLUMN O and others should be left alone.

Does it make sense?

Thanks,

Z

[AliGW]

Do you mean this?

=IF(D3=MAX($D$3:$D$6),D3+1,D3)

[Norie]

Try this in O3 and copy down.

=(D3=MAX($D$3:$D$6))+D3