Hi,
I have a list of numbers in column 2 that I wish to remove from column 1 if they exist. I got as far as identifying whether they exist in column 1 by using VLOOKUP and placing a YES in column 3 if it does.
Any ideas?
Hi,
I have a list of numbers in column 2 that I wish to remove from column 1 if they exist. I got as far as identifying whether they exist in column 1 by using VLOOKUP and placing a YES in column 3 if it does.
Any ideas?
You might want to copy column 2 to another sheet temporarily so you don't delete those too... and then while in any cell of the table, Go to Data|Filter, you should get drop down arrows at top row, filter column 3 for "YES", then select those rows and right-click Delete
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks