View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NEWER USER NEWER USER is offline
external usenet poster
 
Posts: 10
Default AutoFill a large list

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