Delete duplicate values and mantening unique values

**ronald coletto** · 01-18-2013, 03:07 PM

I need help in identifing duplicates values and those values most be deleted and in keeping the unique one between two columns ex.

Column a column b
23 36
35 23
45 95
68 105
95 85
85 75
75 35

results should be = to

column a column b
45 36
68 23
105

**oeldere** · 01-18-2013, 03:29 PM

See the attached file.

I used helpcolumn (see the yellow cells)

The result is in the green cells.

P.s. the number 23 in your example is also duplicated.

**ronald coletto** · 01-18-2013, 04:04 PM

wow thx for the fast reply, i was looking for a vba steps

**oeldere** · 01-18-2013, 04:26 PM

you can record the manual actions with the macro-recorder.

then you get the VBA code.

**xladept** · 01-18-2013, 04:57 PM

Hi Coletto,

Try this:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Press ALT + F11 to open the Visual Basic Editor.

Open a macro-enabled Workbook or save your Workbook As Macro-Enabled

Select “Module” from the Insert menu

Type "Option Explicit" then paste the code into the white space on the right

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name

**ronald coletto** · 01-22-2013, 08:59 AM

wow, you guys are the best....

thx a lot it worked for me and is perfect just the way i wanted in a range of A:A and B:B cuz i have over 300,000 records to compared to

really thx to both of you guys