Soting

[jon]

Hi
I want to rank a list of numbers and then drag the formula down

the formula is
=RANK(G2,G2:G396,1)
but when I drag it down all the numbers increase by 1, I remember you can
use some symbol around the part of the formula so it dose not alter But I
have forgotten what the symbol is.


Thanks

Jon

 

[Ron Coderre]

I *think* you're looking for this:
=RANK(G2,$G$2:$G$396,1)

Does that help?

Regards,

Ron Coderre
Microsoft MVP (Excel)

 

[jon]

Sorted thanks
one day I will remember

Jon

I *think* you're looking for this:
=RANK(G2,$G$2:$G$396,1)

Does that help?

Regards,

Ron Coderre
Microsoft MVP (Excel)

 

[AltaEgo]

change G2:G396 to G$2:G$396