Two issues in this mockup file:
The formula in Column B is designed to auto populate the incremental count of each work order in Column A. (e.g., if Column A has 3 work orders with the same #, show 1, 2, 3). Right now it's jumping to the end of the data table and providing the total count vs. incremental count.
My change event macro works for the most part but I can't get it to completely unfilter if Cell E1 is blank.
More detailed notes in file.
Thank you, Experts!!!