I have an issue with filtering. I have a set of data that has multiple rows (Company Number, Multiple Accounts) example:
Company Number 300 Account 1000
Account 2000
Account 3000
Company Number 400 Account 1000
Account 2000
Account 3000
Is it possible with an advanced filter or macro to filter by the company number and still keep all the accounts? Maybe somehow with grouping? I am completely stumped.
Thanks
Company Number 300 Account 1000
Account 2000
Account 3000
Company Number 400 Account 1000
Account 2000
Account 3000
Is it possible with an advanced filter or macro to filter by the company number and still keep all the accounts? Maybe somehow with grouping? I am completely stumped.
Thanks