SOLVED

Delete Duplicates INCLUDING initial instance

Copper Contributor

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.

3 Replies

=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?

best response confirmed by KinneretKatz (Copper Contributor)
Solution

With legacy Excel, you could identify the entires that appear only once with a conditional formatting formula:

=COUNTIF($H$2:$H$13,$H2)=1

Patrick2788_0-1704311850707.png

 

1 best response

Accepted Solutions
best response confirmed by KinneretKatz (Copper Contributor)
Solution

With legacy Excel, you could identify the entires that appear only once with a conditional formatting formula:

=COUNTIF($H$2:$H$13,$H2)=1

Patrick2788_0-1704311850707.png

 

View solution in original post