Forum Discussion
Solved
Deleting rows
Hi Everyone, I would like to know if it is possible for Excel to automatically delete all occurrences of a row that contains the same text. As an example if a a worksheet contained the followin...
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).
You need VBA macro.