Forum Discussion
Delete entire row after the first occurrence of a value in the a column?
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 ...
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)
Thanks - the Remove Duplicates button solved it for me. But that looks good as well.