Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching for Duplicate Text in a column
I have created a worksheet that lists identification numbers for valves and
instruments on filtration machines. Now these identification numbers are unique because they are a combination of both letters, number and characters. I need to find a way to check if any of these indentifaciton numbers have been duplicated in a column. No 2 numbers are the same and again I need to know how I could check a column in excel for possible duplicates to correct them. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching for Duplicate Text in a column
you can use MATCH to do a self-look up. If it comes back with a match,
it will tell you where the duplicate is. Next to your part number do: =MATCH(item_ID, Range_of_IDs, 0) Good luck! acesandspades101 wrote: I have created a worksheet that lists identification numbers for valves and instruments on filtration machines. Now these identification numbers are unique because they are a combination of both letters, number and characters. I need to find a way to check if any of these indentifaciton numbers have been duplicated in a column. No 2 numbers are the same and again I need to know how I could check a column in excel for possible duplicates to correct them. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching for Duplicate Text in a column
Another way to play it ..
Assuming source data is running in A2 down Place in B2: =IF(A2="","",IF(COUNTIF($A$2:A2,A2)1,"dup","")) Copy B2 down as far as required Col B will flag duplicates in col A as "dup". We could then easily autofilter* on col B for closer inspection of the "dup". *Data Filter Autofilter -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "acesandspades101" wrote: I have created a worksheet that lists identification numbers for valves and instruments on filtration machines. Now these identification numbers are unique because they are a combination of both letters, number and characters. I need to find a way to check if any of these indentifaciton numbers have been duplicated in a column. No 2 numbers are the same and again I need to know how I could check a column in excel for possible duplicates to correct them. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
another text to column problem | Excel Worksheet Functions |