in D use a formula
=ROW() - nn

if the first data row of your table is row 6 then replace nn by 5 , so the
formula returns 1


"NEWER USER" wrote in message
...
I am very new to Excel and am trying to automate a process. I have a
worksheet with 4 columns and 60,000 rows.
Column A Group
Column B Part No
Column C Sales
Column D Rank

I would like to sort the worksheet on Column A (ascending) and then Column
C
(descending). From here, I would like to Autofill Column D beginning with
1
to N and each time the Group changes, start again with 1 to N. Any help
in
getting me started would be appreciated. Thanks