Biggest number in the column.

**sovietchild** · 02-07-2017, 04:22 PM

Hello, I have 10 numbers in one column. What is the formula to find out which number is the biggest?

File attached.

**Amanda Wilso** · 02-07-2017, 04:24 PM

Largest number in the range:
=MAX(A1:A100)

**Amanda Wilso** · 02-07-2017, 04:24 PM

Largest number in the range:
=MAX(A1:A100)

**sovietchild** · 02-07-2017, 04:26 PM

Originally Posted by Amanda Wilso

Largest number in the range:
=MAX(A1:A100)

Thank you!

**sovietchild** · 02-07-2017, 04:27 PM

Originally Posted by Amanda Wilso

Largest number in the range:
=MAX(A1:A100)

How about the biggest before biggest?

**Amanda Wilso** · 02-07-2017, 04:50 PM

=large(a1:a100, 2)

**sovietchild** · 02-07-2017, 05:01 PM

Originally Posted by Amanda Wilso

=large(a1:a100, 2)

Wow, it worked. Thank you so much!

Re: Biggest number in the column.