duplicate data in column

[Big D]

I created a spreadsheet with three columns from data pulled that may not be
correct. One of the columns is MAC address which I know there are duplicates
in this column.

Based off the 500 rows, I am trying to figure how can I find out where a MAC
Address is in the MAC Address more than once. I have found that the MAC
address which is tied to a device could be in two locations and I am trying
to narrow where it might be since the place we get all the data is never
updated.

Excel Format example of the file

Location Number MACAddress
DC1 21 00A0F8610E1C
DC1 20 00A0F8610E19



Below is an example of a MAC Address in two locations
DC1 21 00A0F8610E1C
DC2 21 00A0F8610E1C

 

[Roger Govier]

Hi

In D2 enter
=IF(COUNTIF(C:C,C2)>1,"DUPLICATE","")

and copy down

 

[Guest]

ASAP Utilities, which is a free add-in easily found by Googling "ASAP
Utilities," makes this an easy job.

After installing the add-in, highlight the range that includes your lists,
and go to "ASAP Utilities/Information/Count Duplicates in Selection." This
will color the cells that contain duplicate data (regardless of order) and
give you a count of duplicates. Easy as pie.

Incidently, this is exactly the answer I gave to a posting just a few days
ago. You can often find answers to your questions by searching in the forum
-- also easy as pie: Just type a key word like "duplicates" in the search box
above.