Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtotal of identical data and deleting its duplicate
Good Morning:
I have a column that was use for inventory control. I want to subtotal that column and delete its duplicates. example: abc abc def def def I want column b to give me the count for each repetive cell and then delete the duplitates. The result should be: abc 2 def 3 Please help. Thank you. PaolaAndrea |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtotal of identical data and deleting its duplicate
Hi PaolaAndrea. There is a way, not elegant, but it works. Sort the
inventory items in column A to bring all the duplicate items together. Next, go to data - subtotal and select count. Copy your data and paste special - values to a new worksheet starting in A2. Put labels in A1 and B1. Column A will have abc count and def count and column B will have the abc's, def's and the count of each next to where it says abc and def count. Label column C total and in C2 type: =if(right(a2,5)="count","T","") and copy down the length of your data. This will put a T in Column C in each row that has a count of the inventory items. Sort column C descending to bring all the T's to the top and delete all the rest. Finally, delete Column C and then go to Edit - Replace and Replace the word Count with nothing. Please post back if this is too confusing and I'll try to make it clearer. HTH -- Sincerely, Michael Colvin "PaolaAndrea" wrote: Good Morning: I have a column that was use for inventory control. I want to subtotal that column and delete its duplicates. example: abc abc def def def I want column b to give me the count for each repetive cell and then delete the duplitates. The result should be: abc 2 def 3 Please help. Thank you. PaolaAndrea |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtotal of identical data and deleting its duplicate
If you add headers, you could use data|pivottable.
If you sort your data (after adding headers), you could use data|subtotals and use count. then use the outlining symbols at the left to hide the details. select those cells you can see edit|goto special|visible cells only edit|copy start a new sheet edit|paste You may want to select that first column and edit|replace what: (spacebar)Count with: (leave blank) replace all (and get rid of the bolding.) PaolaAndrea wrote: Good Morning: I have a column that was use for inventory control. I want to subtotal that column and delete its duplicates. example: abc abc def def def I want column b to give me the count for each repetive cell and then delete the duplitates. The result should be: abc 2 def 3 Please help. Thank you. PaolaAndrea -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find duplicate rows then deleting them | Excel Worksheet Functions | |||
Deleting data in a table from excel export | Excel Discussion (Misc queries) | |||
Deleting filtered out data from a worksheet | Excel Worksheet Functions | |||
copy data from one worksheet to identical sheet in different workbook | Excel Discussion (Misc queries) | |||
Deleting excess data in a macro | Excel Discussion (Misc queries) |