Forum Discussion
Solved
Delete Duplicates INCLUDING initial instance
I want to delete any data in my table that has a duplicate, including the first instance. For example, if my table is
Maria
Gabriella
Maria
Estella
I want to be left with
Gabriella
Estella
with ALL instances of Maria being removed. Every method I know for removing duplicates in Excel would leave the list with one unique Maria.
With legacy Excel, you could identify the entires that appear only once with a conditional formatting formula:
=COUNTIF($H$2:$H$13,$H2)=1
=UNIQUE(I9:I12;;TRUE)
You can apply this formula with the names in cells I9:I12.
EDIT:
=UNIQUE(I9:I12,,TRUE)
It's more likely that you are using commas instead of semi-colons i assume.
My Excel doesn't have the Unique formula. Any advice for a substitute?
With legacy Excel, you could identify the entires that appear only once with a conditional formatting formula:
=COUNTIF($H$2:$H$13,$H2)=1
