I'm not using XL2007, but I think this should still work. Let's say the
address is in column F.

In a "helper" column, put this formula =COUNTIF(F2,F$2:F$3500). Then you can
use AutoFilter on this column to display entries 1.


On Thu, 1 Nov 2007 14:50:01 -0700, Charles
wrote:

OK, I'm a real novice here (not familiar with formulas, etc.) and I'm using
Excel 2007 for the first time (was using 2003) with my mailing list of
3,000+. I am constantly adding names/addresses and updating the list. Many
times I'll add, say, Mary Jones at 123 Elm St while not realizing that I
already have Tom Smith at the same address. So, in 2007, there is this great
buttton "Remove duplicates". To try and be sure I'm really removing a
duplicate I check off zipcode (9 digit) and street address. However in the
case of an apt bldg (if the apt # is not listed) that wouldn't work and
possibly there may be some other error. So, I'd like to be able to see what
is removed, (before it is actually deleted) but there doesn't seem to be any
option for that. And that (finally) is my question.
Thanks in advance for any assistance.