using =large()

[BKG SPORTS]

excel 2007

g6=366
g7=396
g8=418
g9=414

in L9 I have =large(g6:g35,1) returns 418, which is right
but it returns 418 in L8,L7,L6

I don't want it to show in the previous cell

is there another formula to use?

 

[kpark91]

MAX(Range)?

 

[Matty]

What do you want the formula to do exactly?

Matty