View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
frukyy frukyy is offline
external usenet poster
 
Posts: 3
Default Find the highest value on the column

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