Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
'conditional format' cells for the highest number in a range | Excel Discussion (Misc queries) | |||
Scores of a Range Cells. Highest or lowest depending a parameter | Excel Worksheet Functions | |||
how do I change the font of highest number in a range of cells | New Users to Excel | |||
How do I return the highest value in a range of cells | Excel Worksheet Functions | |||
How do I Pick a cell with highest value from a range of cells? | Excel Worksheet Functions |