Hello, please help I try to do the following actions via macro but there may be more simple:
A column containing urls
column B containing urls
I'd like urls in column A that also exist in col B are deleted (in col A)
then empty cells in A cause suppression of the corresponding line
Then delete column B
Then I export the remaining column A in a csv file
How could you do that please? using macros or maybe Excel 2013 features advanced functions for this?
thank you very much
I don't understand what you want to do here. Please explain in different terms.then empty cells in A cause suppression of the corresponding line
attaching a sample worksheet would also help
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
You can do what you want without macros or formulae. Select column B and move under column A. Select column A. Click on the data tab then click on Remove Duplicates.
Your list is now ready to be saved as a CSV.
This can be done in less than a minute just using the built in features of Excel.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thanks U . It's perfect
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks