 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006duplicate data in column
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 Hi In D2 enter =IF(COUNTIF(C:C,C2)>1,"DUPLICATE","") and copy down  SignatureRegards Roger Govier >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 [quoted text clipped - 15 lines] > DC1 21 00A0F8610E1C > DC2 21 00A0F8610E1C 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. > 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 [quoted text clipped - 15 lines] > DC1 21 00A0F8610E1C > DC2 21 00A0F8610E1C |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.