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
 
Back
Top