Bonus points for a max value in a range of cells

[Yoti14]

I'm trying to find a max value within 4 cells and then award bonus points for highest.

The max value in BD19:BD22 should then result in 5 points in BE19. since the results will be different everytime, thats why I'm looking for a formula to produce this result.


example of what it should look like when done:

	BD	BE
18	FINISHES	BONUS
19	21	0
20	22	0
21	23	5
22	21	0

<tbody>
</tbody>

Is this possible to achieve?

 

[Aladin Akyurek]

What if we have two or more instances of the max value?

 

[Yoti14]

all awarded the same bonus points then. (5)

 

[Rick Rothstein]

Put this formula in cell BE19 and copy it down to cell BE22...

=5*(BD19=MAX(BD$19:BD$22))

 

[Aladin Akyurek]

In Be19 enter and copy down:

=IF(BD19=MAX($BD$19:$BD$22),5,0)

 

[Yoti14]

THANK YOU both of you! That worked perfectly Much appreciated. Now all I have to do is solve a Auto sort issue and I'm almost done.