Need to delete select data from a column

New 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




3 Replies




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.



Excellent I will..