| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing Duplicates from multiple worksheets
Hi I need to remove duplicates from multiple wotrksheets and then give me the
results in one final worksheet. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing Duplicates from multiple worksheets
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 -- Max Singapore --- "J.S. Will" wrote: Hi I need to remove duplicates from multiple worksheets and then give me the results in one final worksheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Duplicates Help | Excel Discussion (Misc queries) | |||
| removing duplicate entries in multiple worksheets | Excel Worksheet Functions | |||
| How do I check for duplicates across multiple worksheets | Excel Worksheet Functions | |||
| Removing Duplicates | Excel Worksheet Functions | |||
| Removing Duplicates | Excel Discussion (Misc queries) | |||
Hybrid Mode
