duplicate data

Hi using excel XP... am trying to use a macro to exclude duplicate cases, as can't seem to permanently do so with adv filter>exclude duplicates etc despite copying to another data sheet etc. Data example: ID Age INR blood result 2 83 2.4 2 83 2.9 2 83 1.9 2 83 5 3 70 3.8 3 70 4 3 70 8 3 70 3 I...

I would like to restrict duplicate entries from being entered. My criteria for a duplicate entry is a COMBINATION of a number in Column A AND a number Column E (on the same row) is identical to a combination in Columns A and E on some other row - this is a duplicate entry and would not be...

Hi Everyone...I have a list of names (column A) and in column B I want a formula to flag all duplicate items in column A. I was using the formula =IF(COUNTIF($A$2:$A$10,A2)>1,1,0) where "1" would flag me to a possible duplicte (i.e. I could filter on it). The data in column A is causing...

Is there a way to use excel to remove duplicate repeating rows where one column=another column that is not in the same row? Example Date Team1 Team2 3/7/08 tigers wildcats 3/8/08 tigers broncos 3/9/08 tigers mustangs 3/7/08 wildcats tigers 3/8/08 wildcats mavericks 3/9/08 wildcats broncos The...

Hi All, I have a problem with duplicates in my database that I need to remove, but the problem is that some of the duplicates are OK and need to be left alone. Let me clarify....my database imports data that uses a "key" value so that every few days an individual key can get reused. Those are...

I have a list of corporates in one excel sheet. I want to check for duplicates before entering new data and these duplicates are not exact matches. for example I have this corporate list: <TABLE style="WIDTH: 173pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=231...

Ok. I have a column of data. Half the entries in the column will be unique numbers (IP addresses) and half will be the text "DHCP" Since the word "DHCP" will obviously repeat, I am looking for a macro to highlight duplicate numbers and ignore the word "DHCP". The macro I am using in other...

I am trying to sort through a list of data and find duplicates in it. I want to sort through data in column 1 and see if the contents in A1 is the same as any of the other entries in column A (I want it to repeat through the entire list of data in column A) If the entry in A1 is the same as...