Forum Discussion
Solved
Remove all values except some specific ones
Hi all, I got the issue, that I have a list with some SKUs (Sheet: "Accessories") in column A, and for each SKU a list of accessories in column B. The task is to remove all accessories except a s...
Juergen_Thoma I've added a PowerQuery solution to your file. I creates a table with all 945 SKU's. Of these, only 150 have accessories that are on the "Values" list.
Hello Hans,
sorry for the late reply. I used that macro, but what it does for me is to remove all SKUs and the accessories-products column.
What I need is to keep all SKUs, but remove all values from the "accessories-products" column, except the ones which are listed in the "Values" sheet. Sorry if my explanation was unclear in the first post.
Best regards
Jürgen
sorry for the late reply. I used that macro, but what it does for me is to remove all SKUs and the accessories-products column.
What I need is to keep all SKUs, but remove all values from the "accessories-products" column, except the ones which are listed in the "Values" sheet. Sorry if my explanation was unclear in the first post.
Best regards
Jürgen
Juergen_Thoma I've added a PowerQuery solution to your file. I creates a table with all 945 SKU's. Of these, only 150 have accessories that are on the "Values" list.
- Hi Riny,
that works perfectly, thanks a lot.
Best regards
Jürgen