Soting

  • Thread starter Thread starter jon
  • Start date Start date
J

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
 
I *think* you're looking for this:
=RANK(G2,$G$2:$G$396,1)

Does that help?

Regards,

Ron Coderre
Microsoft MVP (Excel)
 
Sorted thanks
one day I will remember

Jon


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

Does that help?

Regards,

Ron Coderre
Microsoft MVP (Excel)
Click to expand...
 
Back
Top