Filtering duplicate information
Hi Rachael,
In an empty column, cocatenate the fields from the columns that you want to
dedup or filter by.
In another empty column do a countif based on the previous step.
Filter on the second column.
Hope this helps.
"Rachael" wrote:
Hi,
I have a large speadsheet where some of the columns are identical.
i want to remove the duplicate rows entirely where the identical columns
occur.
i've tried using the advance filter function but because the rows are
slightly different it doesnt work
can you help please
thanks
|