Dear all excel expert,
I have created a pivot table, and there is one field called item code which I need to filter.
There are easily about 400 item code in that field, and I would need to selectively filter 200 item code as these are the active code in the market.
By default, I will have to selectively filter one by one for that 200 items, and then done deal.
I'm just wondering if there is any quicker way to call out / filter the 200 items, especially if there's additional new item code which would be active in the future.
Appreciate everyone help.
Thanks
Regards
cks1026
Bookmarks