Cross-referencing entries in Excel/Access for duplicates

[Transition]

I'm trying to figure out how in Access or Excel i can cross-reference entries in my mailing lists (postal mailing lists - not e-mail). I currently manage 5-6 individual mailing lists which contain roughly 500 people each. Right now i'm doing everything in Excel with no cross-referencing for duplicate entries. If there is a function in Excel (or better yet something in Access) i can do to just cross reference the 'Company_Name' field for identical entries (although i don't want the query to be case-sensitive) and flag them as being duplicates?

Any help is greatly appreciated!

- RJ

 

[Transition]

bump

 

[EagleKeeper]

Access has the cabability to analyze tables.

Export your spreadsheet, and then run one of the Analysis wizards.

Beware - typos will kill you

 

[Transition]

Originally posted by: EagleKeeper
Access has the cabability to analyze tables.

Export your spreadsheet, and then run one of the Analysis wizards.

Beware - typos will kill you

I'll give it a shot. Thanks for the suggestion.

 

[NeoV]

I have your solution...check your PM