Soting

Giganews Newsgroups
Subject: Soting
Posted by:  jon (jon@nospam.com)
Date: Mon, 30 Mar 2009

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

Replies