Thanks for the response. As I understood it, Rick, the use of XXX
referenced below doesn't do it.
Here's what it looks like:
http://www.editgrid.com/user/mcheng/sample

Michael

On Jun 13, 2:56 pm, "Rick Rothstein \(MVP - VB\)"
wrote:
Right now, the first dup on the list (closest to the top, or Row 1) is
assigned the smallest number, and the largest Row number is assigned
the largest number. Is there a way to reverse that so that the row
closes to the bottom is actually the smallest number and the row
closest to the top has the highest number?

Change Bob's formula to this

=COUNTIF($A1:A$XXX,A1)

where my XXX can be any row number equal to or greater than the last data
row you will ever need.

Rick