Displaying the Highest Value in a user-variable range of cells
I need help with something I think can be done but I'm stuck.
In one worksheet, I've got a range of cells which will be numbers that can
be changed by a user. For example I'll say it's like this:
72
45
26
30
I want to have excel look at that range of numbers and be able to tell that
72 in this case is the highest number and display (result) that (72) in
another cell.
It needs to update so that if someone else goes in and adds in the number 80
within that set range, it will change in the result cell to reflect that 80
is now the highest value in the range.
Any help is much appreciated, Thanks
|