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

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

Good call!

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

thanks

LARGE(Range,1)

Also, gives more options and flexibility.