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

Displaying the Highest Value in a user-variable range of cells
 

Hello Tabby,

If your range was A1:A4 for example, you could use the MAX function ...

=MAX(A1:A4)

This will (providing calculation is set to Automatic .. Tools (menu) |
Options | Calculation (tab) | Automatic (select) ) update as requested.

Regards,
Zack Barresse


"Tabby" wrote in message
...
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