Forum Discussion

KinneretKatz's avatar
KinneretKatz
Copper Contributor
Jan 03, 2024
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...
excel
  • Patrick2788's avatar
    Patrick2788
    Jan 03, 2024

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

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

     

KinneretKatz's avatar
KinneretKatz
Copper Contributor
Jan 03, 2024

My Excel doesn't have the Unique formula. Any advice for a substitute?

Patrick2788's avatar
Patrick2788
Silver Contributor
Jan 03, 2024

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

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

 

Resources