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.
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 O
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.

 

[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.


flapoke

 

[Cutter]

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