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

Find the highest value on the column
 

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

Find the highest value on the column
 

=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

Find the highest value on the column
 

Hi,

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

HTH
Cheers
Carim

Find the highest value on the column
 

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

Find the highest value on the column
 

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