Finding the Largest Value

[123James]

Hi everyone,

What formula should i type into a cell to make it display the biggest value present in a set of numbers across a cell range.

Each cell in the cell range(a column) contains just one number.

Thanks

 

[Rickster57]

large

Did you try MAX(A1:A20) for whatever range of cells?

 

[123James]

Good call!

I must have gone retarded for a moment to miss that one

thanks

 

[shades]

LARGE(Range,1)

Also, gives more options and flexibility.
________
Indica strains