Forum Discussion
Deleting rows
Does your data reside in a single column? If so, you can readily come up with a subset of the unique values, without sorting, by using a combination of COUNTIF and FILTER functions:
The top two gray cells contain the formulas shown above them in their respective columns. Copy the column B formula down through the last of the data. rows.
And perhaps that can be written without the use of the additional column (B).
Thank you for your response.
I would like to delete all three occurrences of the word "help".
I used the above as an example.
In my actual spreadsheet there will be multiple duplications and if I can delete all different duplications that would be great.
The spreadsheet may look more like this:
help
go
help
in
go
out
help
I can sort the list so that all occurrences are together but I would still have to go through the spreadsheet A:Z to find them.
I was hoping that there was a function that would sort through the spreadsheet and find all duplicate rows and then delete all occurrences of the row weather it be in rows 1 and 2 or rows 501 and 502.
Thankyou
Does your data reside in a single column? If so, you can readily come up with a subset of the unique values, without sorting, by using a combination of COUNTIF and FILTER functions:
The top two gray cells contain the formulas shown above them in their respective columns. Copy the column B formula down through the last of the data. rows.
And perhaps that can be written without the use of the additional column (B).