Removing Duplicates from multiple worksheets

  • Thread starter Thread starter J.S. Will
  • Start date Start date
J

J.S. Will

Hi I need to remove duplicates from multiple wotrksheets and then give me the
results in one final worksheet.
 
Stack it up manually into a single sheet (a one-time copy/paste effort,
doable in 1/2 min). Then create a pivot on the stacked data, place the col
header into both ROW and DATA areas (set to Count in DATA), finish up the
wizard. voila, you're done in another 10 seconds. Any joy? hit the YES below
 
You must log in or register to reply here.

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

how do i combine excel worksheets 1
renumbering rows 4
Same Cell Name on Multiple Worksheets 3
Access Auto Matching Duplicates? 0
remove all duplicate records 1
Finding duplicate time punch entries 1
multiple worksheets 1
Creating a duplicate worksheet 1

Back
Top