Data Filteration

[Bandc]

I have sets of 2 lists. One are sold items list (SKU) and other Stock (SKU) list.
We want to filter and delete sold sku from Stock sku list.

 

[PCosta87]

Hi,

Welcome to the forum

There are multiple ways of doing it. One would be using advanced filters:

1. Make a copy of the sold items list and rename the header exactly the same as the Stock (SKU) list:
2. Now, from the DATA tab, select advanced filter:
3. Then, select to filter in place and fill in the criteria range:
4. Press Ok and it will show only the sold items in the stock items list. Delete.

One other way could be to use a VLOOKUP to search the stock items on the sold items list. All items that were not sold will return an error... filter the errors out and delete all remaining (see attached excel sample file)

Hope this helps

 

[Bandc]

Dear Pcosta,
A Ton Of Thank you for solving my request.......

 

[PCosta87]

Dear Pcosta,
A Ton Of Thank you for solving my request.......

Don't mention it... glad I could help

 

[Bandc]

Please solve this.... The equation you send it not working for me... please help....

 

[PCosta87]

Hi,

If you wish to use the VLOOKUP approach then place the VLOOKUP in a helper column (I used "G") and filter the errors out (see attachment).
The resulting list is the items that were sold... delete them or do whatever you wish at this point:

Feel free to ask any further questions.

Hope this helps.

 

[Bandc]

Thanks Now it solved my problem.

 

[PCosta87]

Thanks Now it solved my problem.

Don't mention it