Find the highest value on the column

[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

 

[Kevin B]

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

=MAX(A1:A39)

 

[Dave F]

=MAX([range])

 

[Carim]

Hi,

=Max(A:A) or whatever column you are using ...

HTH
Cheers
Carim

 

[frukyy]

Kevin,
Thanks,
I really appreciate your quick answer.
Faruk Gashi

 

[frukyy]

Thanks to all of you,
I hope one day I can assist you guys with something
Faruk Gashi