Excel Question = Reference a Whole Column?

[edro]

=LARGE(A1:A100,1)

That returns the 1st largest number in the selection A1 to A100.

Can I return the 1st largest number in the whole A column?

=LARGE(COLUMN(A),1) or something like that?

I can't seem to find the answer anywhere.

Thank you if you help me or attempt to help!

 

[sciencewhiz]

How about =MAX(A:A)

That may work with LARGE as well, but openoffice doesn't have LARGE, so I can't test it.

 

[NeoV]

MAX FTW

 

[edro]

Originally posted by: sciencewhiz
How about =MAX(A:A)
That may work with LARGE as well, but openoffice doesn't have LARGE, so I can't test it.

MAX FTW!

It works great.

Thank you!