Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Autofill list | Excel Discussion (Misc queries) | |||
Producing an automated list from a large list | Excel Worksheet Functions | |||
Autofill a list | Excel Worksheet Functions | |||
Using a list box to autofill | Excel Discussion (Misc queries) | |||
remove small list from large list | Excel Discussion (Misc queries) |