Delete numbers from the first two cols if they are not equal to the numbers in third cols

As shown in the image, there are three columns. The third column is the leading column because the numbers will be deleted in the first two columns based on that. What I don't know what excel function to use to delete the numbers from first and second column that do no exist in the third column. The highlighted ones in yellow are the ones that needs to be deleted. This is a just a sample. I have a dataset with million data points. And, I also want the cells to shift up.

Thanks!!

pic.jpg

Originally Posted by mastermind11

As shown in the image, there are three columns. The third column is the leading column because the numbers will be deleted in the first two columns based on that. ...And, I also want the cells to shift up.

From your description it would appear that you want change the 1st and 2nd columns so that they are exactly like the 3rd column. If that is the case then I would think that you could paste the following formula in cell A2 and copy over and down:

Please Login or Register  to view this content.

Let me know if you have any questions.

The only way to shift cells up is to use a macro. However, once you start shifting cells up, what ever matches you had below will be destroyed.
You could use helper columns on the same sheet or a different sheet

Please Login or Register  to view this content.

---

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets