Deleting rows that are NOT duplicates

Hi, welcome to the forum

I have closed your other thread, forum rules preclude posting duplicate threads.

1 way to do this would be to use a helper column, like this...

	A	B
1	ID	Helper
2	aa	2
3	bb	2
4	dd	1
5	cc	1
6	ee	1
7	aa	2
8	bb	2

B2=COUNTIF(A:A,A2)
copied down.

You would then apply filters (Home tab/Editing/SortsAndFilter/Filter
on the dropdown, uncheck ALL and check 1
delete all rows that remain
Remove the filter

You should be left with only duplicate ID's
You can then (if you want) delete the helper column

Hi e,

Welcome to the Forum! (I posted this in the thread closed by Ford)

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

If you haven't used macros before you'll need to go to:
File- options - trust center -trust center settings - macro settings ,
the second option down (disable all macros with notification)

Then - Copy the code to the clipboard

Open your Workbook

Press ALT + F11 to open the Visual Basic Editor.

Select "Module" from the Insert menu

Type "Option Explicit" then paste the code under it

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

@ Orrin, apologies, must have been a timing issue, I did not see your post, otherwise I would have closed this 1

@Ford - Not to worry, it was no problem since you had also posted the link