Hi,
=LARGE(c1:c4,1)

1 will give you the largest
2 will give you the 2nd largest and so on

If this helped please click yes, thanks

"MAX" wrote:

I have a range of cells with a number in each cell (below).
Cell C1 24
Cell C2 12
Cell C3 14
Cell C4 7

I want a formula that gets the largest number in Cell B1.

Thanks.