Identifying Duplicates (text) w/o Deleting Them All

KeithS.

New Member
Joined
Jul 11, 2012
Messages
17
Using Excel 2010:
I'm working with a very long list of vocabulary words & definitions and need to clean out duplicates. I followed the directions at http://www.techrepublic.com/blog/msoffice/how-to-find-duplicates-in-excel/842 to copy only unique records to another location.


It worked, but then I realized that it stripped out every single instance of a repeated term. I needed to keep some of the duplicates because of the type of data I'm working with. I have duplicate terms from both Spanish & French (such as colors and days of the week) and I need to keep both words with their English definitions.

For example:

In the French section, I have this:
6801: jeune
6802: young

And in Spanish:
18198: joven (pl. jóvenes)
18199: young

In French, I have this:
7057: lundi
7058: Monday
7059: mardi
7060: Tuesday
7061: mercredi
7062: Wednesday
7063: jeudi
7064: Thursday
7065: vendredi
7066: Friday
7067: samedi
7068: Saturday
7069: dimanche
7070: Sunday

And in the Spanish section, I have this:
17983: domingo
17984: Sunday
17985: lunes
17986: Monday
17987: martes
17988: Tuesday
17989: miércoles
17990: Wednesday
17991: jueves
17992: Thursday
17993: viernes
17994: Friday
17995: sábado
17996: Saturday

And again in French:
7209: orange
7210: orange

Is there any easy way to find/highlight all the duplicates and then search through them to delete the one I want to delete and keep the ones I want to keep?

Thanks in advance!
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
heres one way assuming only 2 rows per word make sure each section starts on an even row insert a row if necessary
Excel Workbook
ABC
1listhelper(you need this cell)
2domingodomingo Sunday
3Sundaydomingo Sunday
4luneslunes Monday
5Mondaylunes Monday
6martesmartes Tuesday
7Tuesdaymartes Tuesday
8mircolesmircoles Wednesday
9Wednesdaymircoles Wednesday
10juevesjueves Thursday
11Thursdayjueves Thursday
12viernesviernes Friday
13Fridayviernes Friday
14sbadosbado Saturday
15Saturdaysbado Saturday
16mircolesmircoles Wednesdaydelete me
17Wednesdaymircoles Wednesdaydelete me
18domingodomingo Sundaydelete me
19Sundaydomingo Sundaydelete me
20jeunejeune young
21youngjeune young
22joven (pl. jvenes)joven (pl. jvenes) young
23youngjoven (pl. jvenes) young
24orangeorangeorange
25orangeorangeorange
26joven (pl. jvenes)joven (pl. jvenes) youngdelete me
27youngjoven (pl. jvenes) youngdelete me
Sheet1
Excel Workbook
C
2 
3 
4 
5 
6 
7 
Sheet1
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,237
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top