need help with a solution - maybe vlookup?

[Noetic76]

Hi, I have a list of documents with unique IDs that were delivered;
electronically, posted or faxed. There are duplicates in the ID column
because some docs were posted AND sent electronically - I need to isolate ID
numbers that are duplicated by multiple-delivery methods. Can a vlookup do
this?
very much a newbie with lookup, and the list is very big...
thanks!

 

[Fred Smith]

You want Countif. If your IDs are in column A, use:
=Countif(A:A,a1)
and copy down.

Any result more than one means a duplicated ID.

Regards,
Fred

 

[Bernie Deitrick]

Noetic,

Use a formula like

=IF(COUNTIF(A:A,A2)>1,"Duplicate","")

in cell B2, and copy down. Then you can filter or sort to find the
Duplicated values in column A.

If your list of IDs is in column E, then you would use

=IF(COUNTIF(E:E,E2)>1,"Duplicate","")

HTH,
Bernie
MS Excel MVP

 

[Noetic76]

Thanks a bunch Fred and Bernie, we're cooking with gas now!