Need to delete select data from a column

Copper Contributor

I have a file downloaded from a supplier. The  list has thousandths of SKU numbers of their inventory and another column for quantity for each.  

 

I need to filter out all those SKU #'s that I do not need and  keep only the SKU #'s that pertain to my inventory about 50 SKU's or so. how do I go about this 

 

Thank you in advance

 

tapanrack01_0-1625442026962.png

 

3 Replies

@tapanrack01 

 

 

If you’re looking to ask a question or start a conversation about Excel, you’re in the right place!  Ask away.

 

Please include the following info to help others answer your question:

 

Once you got a good answer to your question, please accept it as solution to help others looking for answer to the same/similar question.

 

Thanks!

Excellent I will..