Yes, there will be "ties". Thanks.
"Gary''s Student" wrote:

Will there be "ties" in the data? That is, duplicate values?
--
Gary''s Student - gsnu200909


"Darryl" wrote:

I have 100 (100 rows) with different numbers all in one column. I have
ranked them in another column by largest to smallest in the past. The 100
numbers change from time to time. I would like the rankings to automatically
update. I wish not to sort. Is there a formula?

Thanks, Darryl