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 Est...
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