How do I do this in Excel?

P

PC

You could use Data Filter to eliminate the duplicates.

Data/Filter/Advanced and make sure you select the "Unique
Items Only" option.

Though, Access would be a better tool if you have a large
amount of data to sort through.

HTH

PC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

New computer, how do i move outlook 365 ENTIRELY? 0
Place picture in Excel cell 0
Filtering for unique records (Excel 2007) 0
Eliminate Duplicate Entries in Order to Create Labels Using Mail M 3
Spreadsheet - Deleting Duplicate Records - Self Checking 1
How do I set focus (and select text) on a text box on a modeless userform? 0
How to create portable Excel applications? 2
Extracting unique entries 6

Top