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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro storing as a date? 11
Find Highest Date in a range 4
Highest Value In A Range 6
Highlight highest numbers in a range. 1
Range Selection - From Lowest 2 Highest Values? 2
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Runtime error 91 4
Macro to search range for a portion of a specific value and if findit - then paste formula in anothe 1

Back
Top