=RANK(A1,OFFSET($A$1,0,0,COUNTA($A$1:$A$1000)))
will create a dynamic list that changes with the length of your list


"koty" wrote in message
...
I have a markssheet in which I want to use the Rank formula wherein it
keeps
updating the rank of each student as I keep adding the students.
I do not want to specify a range of cells for it to compare. It should
automatiocally sense the presense of Data and allocate rank accordingly.