Excel Formula Help PLEASE !!!

[flapokey]

Hello,

I am new using Excel and have run into something I can not figure out.

I have a colum with number the get larger as you go down the colum. I want the biggest number to be in a certian cell.

Lets use

M1 THRU M20
M1 IS $10
M4 IS $30
M6 IS $40
M10 IS $50
M15 IS $100

I WANT M15 TO MOVE TO C2

tHE PROBLEM IS THAT I HAVE TO USE ALL THE CELL M1 THUR M20 AS ONE OF THE CELL ME BE THE GREATER AND MOVE TO C2.

I HOPE I EXPLAINED THIS CORRECTLY. PLEASE HELP,

FLAPOKEY

[Roger Govier]

Maybe
C2=LARGE(M1:M20)

By the way, try not to use all capitals in your writing. It makes it more
difficult to read and is regarded by many as shouting!!!
I know that's not whatt you meant to do.


--
Regards

Roger Govier


"flapokey" <flapokey.1ue3mb_1125090303.3725@excelforum-nospam.com> wrote in
message news:flapokey.1ue3mb_1125090303.3725@excelforum-nospam.com...
>
> Hello,
>
> I am new using Excel and have run into something I can not figure out.
>
> I have a colum with number the get larger as you go down the colum. I
> want the biggest number to be in a certian cell.
>
> Lets use
>
> M1 THRU M20
> M1 IS $10
> M4 IS $30
> M6 IS $40
> M10 IS $50
> M15 IS $100
>
> I WANT M15 TO MOVE TO C2
>
> tHE PROBLEM IS THAT I HAVE TO USE ALL THE CELL M1 THUR M20 AS ONE OF
> THE CELL ME BE THE GREATER AND MOVE TO C2.
>
> I HOPE I EXPLAINED THIS CORRECTLY. PLEASE HELP,
>
> FLAPOKEY
>
>
> --
> flapokey
> ------------------------------------------------------------------------
> flapokey's Profile:
> http://www.excelforum.com/member.php...o&userid=26690
> View this thread: http://www.excelforum.com/showthread...hreadid=399609
>

[Cutter]

Try =MAX(M1:M20) in Cell C2

If using the LARGE() function it would have to be =LARGE(M1:M20,1)

without the ,1 after the M1:M20 you'll get an error message

[flapokey]

Thank You everyone that last post worked great thank you.


flapokey

[Cutter]

You're welcome. Glad you've got it working.