I didn't know if I should have posted this in Excel or Access since I'm manipulating an Excel workbook from within Access using VBA but here goes.
In my worksheet I need to filter for a particular value in one column and then delete rows where another value appears more than five times. For example, let's say I'm filtering one column to show all addresses in the United States only, leaving out any other country. I then need to make sure there are no more than five rows showing each state's name in the state column. So I couldn't have more than five rows showing "CA" or "TX" or any other state in the state column. I can only leave a maximum of five rows for each state in the worksheet.
I'd sure appreciate any ideas along these lines. Thanks in advance.