Hi All:
I've never used Advanced Filter and I'm having trouble getting the results I want.
Here's my problem -
I have a list of about 12,000 SKUs along with their price and description in columns D,E,F. I need to remove about 2,000 of those SKUs from the original list and I have those SKUs on a separate tab.
Can I use Advanced Filter for this? If so how? The info I've found online hasn't helped.
And if not, is there a clean way to do this? I'm going to need to repeat this process for several months of data (excluding different SKUs each time of course).
Thanks in advance.
I've never used Advanced Filter and I'm having trouble getting the results I want.
Here's my problem -
I have a list of about 12,000 SKUs along with their price and description in columns D,E,F. I need to remove about 2,000 of those SKUs from the original list and I have those SKUs on a separate tab.
Can I use Advanced Filter for this? If so how? The info I've found online hasn't helped.
And if not, is there a clean way to do this? I'm going to need to repeat this process for several months of data (excluding different SKUs each time of course).
Thanks in advance.