splendidmonkey
Technical User
How do I find duplicate values
Don’t say use find and replace there are over 20,000 possible duplicate codes
I have an excel sheet with 3 columns
It looks like this
Column 1
2513
244
2235
1247
1733
1020
2000
2277
Column 2
381
376
375
372
367
359
358
356
Column 3
0#CNGEQCH.LP 0#HKGARB.LP 0#HKGBDAPC.LP 0#HKGBDAPCCO.LP 0#HKGBDASD.LP
0#.DJIW.HK 0#.HSCCW.HK 0#.HSCEW.HK 0#.HSFM25W.HK 0#.HSIW.HK
/1SELH4 /1SELH5 /1SELH6 /1SELH7 /1SELH8
/A#EQCITP_t.PA /A#FOR2_t.S /A#FOR4_t.S /A#FOR5_t.S /A#IWNT.VI
/AEG04SB.AT /AEG04SL.AT /AKT04SB.AT /AKT04SL.AT /ALA04SB.AT
.AM.AS .AM.AT .AM.AVK .AM.BE .AM.BM
0#ABANA.IS 0#ACIBD.IS 0#ADANA.IS 0#ADBGR.IS 0#ADEL.IS
0#1515C2.T 0#1802C7.T 0#1815C3.T 0#1820C7.T 0#1820C8.T
Now what I need to do is search for duplicate values in column 3 to make this harder I am not looking for the whole contents of the cell in column 3 I am looking for individual codes, each cell in column 3 contains between 3 and 11 codes i.e. 1st in column 3 is 0#CNGEQCH.LP I need to find duplicates of this in other cells.
That cell also contains 0#HKGARB.LP 0#HKGBDAPC.LP 0#HKGBDAPCCO.LP 0#HKGBDASD.LP I need to find duplicate occurrences of these also and so on
This table is over 6000 rows long so I really need to do a batch job as individually it would take the rest of my life
Any help would nice
Don’t say use find and replace there are over 20,000 possible duplicate codes
I have an excel sheet with 3 columns
It looks like this
Column 1
2513
244
2235
1247
1733
1020
2000
2277
Column 2
381
376
375
372
367
359
358
356
Column 3
0#CNGEQCH.LP 0#HKGARB.LP 0#HKGBDAPC.LP 0#HKGBDAPCCO.LP 0#HKGBDASD.LP
0#.DJIW.HK 0#.HSCCW.HK 0#.HSCEW.HK 0#.HSFM25W.HK 0#.HSIW.HK
/1SELH4 /1SELH5 /1SELH6 /1SELH7 /1SELH8
/A#EQCITP_t.PA /A#FOR2_t.S /A#FOR4_t.S /A#FOR5_t.S /A#IWNT.VI
/AEG04SB.AT /AEG04SL.AT /AKT04SB.AT /AKT04SL.AT /ALA04SB.AT
.AM.AS .AM.AT .AM.AVK .AM.BE .AM.BM
0#ABANA.IS 0#ACIBD.IS 0#ADANA.IS 0#ADBGR.IS 0#ADEL.IS
0#1515C2.T 0#1802C7.T 0#1815C3.T 0#1820C7.T 0#1820C8.T
Now what I need to do is search for duplicate values in column 3 to make this harder I am not looking for the whole contents of the cell in column 3 I am looking for individual codes, each cell in column 3 contains between 3 and 11 codes i.e. 1st in column 3 is 0#CNGEQCH.LP I need to find duplicates of this in other cells.
That cell also contains 0#HKGARB.LP 0#HKGBDAPC.LP 0#HKGBDAPCCO.LP 0#HKGBDASD.LP I need to find duplicate occurrences of these also and so on
This table is over 6000 rows long so I really need to do a batch job as individually it would take the rest of my life
Any help would nice