Find the highest value on the column

  • Thread starter Thread starter frukyy
  • Start date Start date
F

frukyy

Hi all,

If I enter on column numbers not in consecutive order, is there a way
to find the highest (latest) value that I entered.

Ex:
check
5
4
1
18
8
17
19
20
9
2
7
16
25
21
10
13
6
22
24
12
15
23
14
11
27
26
3

The largest value entered is 27. But in a few days the list will be
larger is there a formula that can do this.

Thank you
Faruk Gashi
 
use the MAX function, changing the cell address range to correspond with the
cells in your worksheet:

=MAX(A1:A39)
 
Thanks to all of you,
I hope one day I can assist you guys with something :)
Faruk Gashi
 
Back
Top