I need a formula to compare 2 cells. I want the result of the highest value
cell to show up in the cell with the formula. Either cell can be the highest
value cell at any given time.

For example, cell BK27 has a value of 25
Cell BK43 has a value of 29
I want cell BK22 (which has the formula) to show the value of BK43 (29) in it.

However, if cell BK27 were to change to 40, I would want the value of 40 to
show in BK22.

Does that make sense?
--
Thanx,