=MAX([range])
--
Brevity is the soul of wit.


"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