Yes, it is.
The logic you are using to find your bouncing emails would actually do this,
with a few changes.
Since you are working in Excel 2004, you can use VBA to find your
duplicates, and that's what *I* would do, because it's a simple one-click
option:
To use a Visual Basic macro to compare the data in two columns, use the
steps in the following example:
1. Start Excel.
2. Press ALT+F11 to start the Visual Basic editor.
3. On the Insert menu, click Module.
4. Enter the following code in a module sheet:
Sub Find_Matches()
Dim CompareRange As Variant, x As Variant, y As Variant
' Set CompareRange equal to the range to which you will
' compare the selection.
Set CompareRange = Range("C1:C5")
' NOTE: If the compare range is located on another workbook
' or worksheet, use the following syntax.
' Set CompareRange = Workbooks("Book2"). _
' Worksheets("Sheet2").Range("C1:C5")
'
' Loop through each cell in the selection and compare it to
' each cell in CompareRange.
For Each x In Selection
For Each y In CompareRange
If x = y Then x.Offset(0, 1) = x
Next y
Next x
End Sub
5. Press ALT+F11 to return to Excel.
Personally, I would change that around a bit to make it easier to use.
OzGrid sells an add-in where they have done all the work for you.
http://www.ozgrid.com/Services/Excel_Duplication_Add-in.htm
That "should" run in Excel 2004, although you may have to modify the code
slightly. It will run in Excel 2011.
Cheers
Thanks, John, looks a lot more complex that extracting with filter using
"unique cells' checkbox.
A few months ago, the owner of a bulk emailer, showed me some you tube videos
for learning the V look up. This was so great. Now I can know which emails in
a list have bounced. But it was very very hard to learn that. But worth it.
This seems in that league. Not sure it's worth it right now, but I'm
archiving the page. If you know of a video on it let me know.
--
The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!
John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:
[email protected]
