Editing duplicate rows (XP)

Topic

New Reply

I have several spreadsheets to combine. I am copying each worksheet and then adding it to the bottom of the spreadsheet, and then doing a sort to see if any duplicates exist. Right now, I am manually deleting any duplicate rows. Is there an easier way to pull all of the unique data out? This spreadsheet is thousands of rows. Thanks.

Reply | Quote

Replies

Use Advanced Filter, or look at this very recent thread: post 344974 plus reply.

Reply | Quote

See my reply to your other post. I still need assistance with macro.

Reply | Quote

Have you tried Data | Filter | Advanced Filter…, Copy to Another Location and Unique Values Only? No macro needed at all.

Reply | Quote

Have you tried Data | Filter | Advanced Filter…, Copy to Another Location and Unique Values Only? No macro needed at all.

Reply | Quote

Getting error when try to copy to another location. See attached. Getting around it when I copy just visible cells and move to another location

Reply | Quote

With Advanced Filter, you can only copy to another location on the same worksheet. Afterwards, you can copy the result to another worksheet. Copying visible cells only will also work.

Reply | Quote

With Advanced Filter, you can only copy to another location on the same worksheet. Afterwards, you can copy the result to another worksheet. Copying visible cells only will also work.

Reply | Quote

Getting error when try to copy to another location. See attached. Getting around it when I copy just visible cells and move to another location

Reply | Quote

See my reply to your other post. I still need assistance with macro.

Reply | Quote

I think the advanced filter will work for me! Thanks!

Reply | Quote

I think the advanced filter will work for me! Thanks!

Reply | Quote

Use Advanced Filter, or look at this very recent thread: post 344974 plus reply.

Reply | Quote