Delete entire row after the first occurrence of a value in the a column?

Iron Contributor

Hello,

I have a list of phone calls. All the phone numbers are in the A column

I just want the first occurrence tracked o the spreadsheet - e.g.

A1 555-1212

a2 555-1414

A3 555-1414

A4 555-1818

A5 555-1212

A6 555-1414

A7 555-1818

A8 555-9999

would just have the following rows when the formula was complete

A1 555-1212

A2 555-1414

A3 555-1818

A4 555-9999

2 Replies

@Boe Dillard 

You can enter this formula in cell B1 and fill it down.

=COUNTIFS($A$1:A1;A1)

Then this formula in cell C1 spills the results.

=FILTER(A1:A8,B1:B8=1)

delete after first occurrence.png

Thanks - the Remove Duplicates button solved it for me. But that looks good as well.