Forum Discussion
How can I retain the row position when removing duplicate values?
In a column I have a group of duplicate values, followed by another group of duplicate values (that are different from the first group), followed by another, etc. For example, 1-Dec 1-Dec 1-Dec 2-D...
Hi Garrett Doll,
- First order the column containing the duplicate values in ascending order.
- Place a helper column with some name say "filter" beside the above column.
- Place zero in the first cell of the above helper column
- Then place the below formula in the 2nd cell of the helper column
- Drag the formula until you need it
- Apply the filter on all columns and then uncheck all values except zero in the helper column
- Delete the filtered values in the Duplicates column
- Now remove the filters from all columns, you should be left with the result that you desired for.
Thanks,
Bala..