Identifying Duplicate content in Excel 2007

[tg-tis]

I have a few worksheets that will be imported into tables in an Access DB. I need to calidate that no cells in specific colums are duplicates.

The 1st spreadsheet has two colums. There should be no dupes by row or dups in any cell of column B.

The 2nd spreadsheet has three columns - Buulding, Unit and Address. Each building can have 4 to 6 units and each have their own address.
I need to identify these situations if the exist:

1. Any duplicate rows of Building & Unit? Columns a & b.
2. Any duplicate units. Column b
3. Any duplicate addresses. Column c

Thanks in advance for your suggestions.

[DGagnon]

you can use the remove duplicates function in excel to accomplish this, just select your table then go to Data on the ribbon -> remove duplicates then select the columns where you want to look for duplicates.

best of luck

-Dan

[tg-tis]

Before I remove a duplicate, I need to identify them and possibly fix the data to correct it. How do I identify without deleting them?

[DGagnon]

you could insert an aditional column next to the column to be checked and use the following formula to identify duplicates

=IF(COUNTIF(B:B,B1)>1,"Duplicate","")