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

Hi tapanrack01, follow the instructions on this post:https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_o365b/updating-prices-in-excel-documents-when-price/d897642a-647b-406b-bc42-6e21b61006d9?messageId=19c14021-261b-4873-9cb7-c7c8e10b3e75 cheers

tapanrack01 Welcome to your Excel discussion space! 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:Device and OS platform, e.g., PC/Windows 10 (see Which version of Windows operating system am I running?) or Mac/macOS Big Sur 11.2.1 (see Find out which macOS your Mac is using)Excel product name and version number (see About Office: What version of Office am I using?)Excel file you’re working with or sample file with data – please remove all confidential and PII data As much context of what you're trying to do - and why - as possible, e.g., how what you're trying to do fits into what larger process or workflow*Expected result and method to achieve the result** 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!

Need to delete select data from a column

3 Replies

NikolinoDE
Platinum Contributor
Jul 05, 2021
tapanrack01

Welcome to your Excel discussion space!

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:
Device and OS platform, e.g., PC/Windows 10 (see Which version of Windows operating system am I running?) or Mac/macOS Big Sur 11.2.1 (see Find out which macOS your Mac is using)
Excel product name and version number (see About Office: What version of Office am I using?)
Excel file you’re working with or sample file with data – please remove all confidential and PII data
As much context of what you're trying to do - and why - as possible, e.g., how what you're trying to do fits into what larger process or workflow*
Expected result and method to achieve the result**

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!
Yea_So
Bronze Contributor
Jul 05, 2021
Hi tapanrack01,

follow the instructions on this post:
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_o365b/updating-prices-in-excel-documents-when-price/d897642a-647b-406b-bc42-6e21b61006d9?messageId=19c14021-261b-4873-9cb7-c7c8e10b3e75

cheers
- tapanrack01
  Copper Contributor
  Jul 05, 2021
  Excellent I will..

Forum Discussion

Need to delete select data from a column

3 Replies

Welcome to your Excel discussion space!

Resources