dizzyfreedom
New Member
- Joined
- Jul 19, 2012
- Messages
- 6
I need to delete pairs of rows that contain the same data in column G [which are email addresses]. I have 2 sets of data from seperate sources, merged together in a single sheet and sorted on Col G. Column A-F also have additional info [name/title/city/state, etc]. I have around 4000 rows. I need to be left with a set of data that is unique to my primary source, so anything appearing in both data sources can go. I should be left with around 800 rows [email addresses] after eliminating them.
Can you help with this? Any suggestions are welcomed! Thank you!!!
Can you help with this? Any suggestions are welcomed! Thank you!!!