Thanks to all of you,
I hope one day I can assist you guys with something :)
Faruk Gashi
CUNY
frukyy wrote:
Kevin,
Thanks,
I really appreciate your quick answer.
Faruk Gashi

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

=MAX(A1:A39)


--
Kevin Backmann


"frukyy" wrote:

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