Excel formula

C

Cecil McIntyre

I would like to have a column of numbers, ever increasing and show the
highest number in a seperate cell.

Target cell 100

15
25
30
45
100
I don't know where to start if this an IF function or not. The target cell
would be frozen and be current as the days go by.

Any help would be greatly appreciated.

Cecil
 
J

J.E. McGimpsey

One way:

A1: =MAX(A2:A65536)


Cecil McIntyre said:
I would like to have a column of numbers, ever increasing and show the
highest number in a seperate cell.

Target cell 100

15
25
30
45
100
I don't know where to start if this an IF function or not. The target cell
would be frozen and be current as the days go by.

Any help would be greatly appreciated.

Cecil
Click to expand...
 
Top