| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to remove duplicates ONLY within the same category
Hi, grateful if you could help me on this regarding removing duplicates ONLY
within the same category but not across categories. e.g. item category hair hair restoration hair loss hair restoration hair hair restoration hair hair care shampoo hair care I want to return - item category hair hair restoration hair loss hair restoration hair hair care shampoo hair care Any help would be much appreciated! Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to remove duplicates ONLY within the same category
Use Advance Filter to show only unique records.
Data menu - Filter - Advance Filter - Select range data and also check "Unique records only" And if you want to copy filtered data to another location then specify location. Hope this helps !! "Landa" wrote: Hi, grateful if you could help me on this regarding removing duplicates ONLY within the same category but not across categories. e.g. item category hair hair restoration hair loss hair restoration hair hair restoration hair hair care shampoo hair care I want to return - item category hair hair restoration hair loss hair restoration hair hair care shampoo hair care Any help would be much appreciated! Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to remove duplicates ONLY within the same category
Hi Himani,
Thanks a lot for your suggestion! I have tried this method before but while it can filter out the duplicate for "hair hair restoration", it will also filter "hair hair care". However, I want to filter duplicate within the same category only. If the duplicate appears in another category, I want to retain it. Is there a way to do it? Thanks! Landa "Himani" wrote: Use Advance Filter to show only unique records. Data menu - Filter - Advance Filter - Select range data and also check "Unique records only" And if you want to copy filtered data to another location then specify location. Hope this helps !! "Landa" wrote: Hi, grateful if you could help me on this regarding removing duplicates ONLY within the same category but not across categories. e.g. item category hair hair restoration hair loss hair restoration hair hair restoration hair hair care shampoo hair care I want to return - item category hair hair restoration hair loss hair restoration hair hair care shampoo hair care Any help would be much appreciated! Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to remove duplicates ONLY within the same category
Hi
First, you have to put them in the same cell using A1&b1 into a column. Then use advanced filters. The split the column using data-text to columns. G. "Landa" wrote: Hi Himani, Thanks a lot for your suggestion! I have tried this method before but while it can filter out the duplicate for "hair hair restoration", it will also filter "hair hair care". However, I want to filter duplicate within the same category only. If the duplicate appears in another category, I want to retain it. Is there a way to do it? Thanks! Landa "Himani" wrote: Use Advance Filter to show only unique records. Data menu - Filter - Advance Filter - Select range data and also check "Unique records only" And if you want to copy filtered data to another location then specify location. Hope this helps !! "Landa" wrote: Hi, grateful if you could help me on this regarding removing duplicates ONLY within the same category but not across categories. e.g. item category hair hair restoration hair loss hair restoration hair hair restoration hair hair care shampoo hair care I want to return - item category hair hair restoration hair loss hair restoration hair hair care shampoo hair care Any help would be much appreciated! Thanks! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to remove duplicates ONLY within the same category
If you use A1&"-"&B1 then, text to column transformation will be more useful.
"Gunnar Lysaker" wrote: Hi First, you have to put them in the same cell using A1&b1 into a column. Then use advanced filters. The split the column using data-text to columns. G. "Landa" wrote: Hi Himani, Thanks a lot for your suggestion! I have tried this method before but while it can filter out the duplicate for "hair hair restoration", it will also filter "hair hair care". However, I want to filter duplicate within the same category only. If the duplicate appears in another category, I want to retain it. Is there a way to do it? Thanks! Landa "Himani" wrote: Use Advance Filter to show only unique records. Data menu - Filter - Advance Filter - Select range data and also check "Unique records only" And if you want to copy filtered data to another location then specify location. Hope this helps !! "Landa" wrote: Hi, grateful if you could help me on this regarding removing duplicates ONLY within the same category but not across categories. e.g. item category hair hair restoration hair loss hair restoration hair hair restoration hair hair care shampoo hair care I want to return - item category hair hair restoration hair loss hair restoration hair hair care shampoo hair care Any help would be much appreciated! Thanks! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to remove duplicates ONLY within the same category
This is great! Thanks Veterinary_Medicine and Gunnar Lysaker :)
"Veterinary_Medicine" wrote: If you use A1&"-"&B1 then, text to column transformation will be more useful. "Gunnar Lysaker" wrote: Hi First, you have to put them in the same cell using A1&b1 into a column. Then use advanced filters. The split the column using data-text to columns. G. "Landa" wrote: Hi Himani, Thanks a lot for your suggestion! I have tried this method before but while it can filter out the duplicate for "hair hair restoration", it will also filter "hair hair care". However, I want to filter duplicate within the same category only. If the duplicate appears in another category, I want to retain it. Is there a way to do it? Thanks! Landa "Himani" wrote: Use Advance Filter to show only unique records. Data menu - Filter - Advance Filter - Select range data and also check "Unique records only" And if you want to copy filtered data to another location then specify location. Hope this helps !! "Landa" wrote: Hi, grateful if you could help me on this regarding removing duplicates ONLY within the same category but not across categories. e.g. item category hair hair restoration hair loss hair restoration hair hair restoration hair hair care shampoo hair care I want to return - item category hair hair restoration hair loss hair restoration hair hair care shampoo hair care Any help would be much appreciated! Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Assistance: Average/Remove Duplicates | Excel Discussion (Misc queries) | |||
| Compare columns remove duplicates | Excel Discussion (Misc queries) | |||
| Can you remove duplicates from Pivot Table? | Excel Discussion (Misc queries) | |||
| Remove duplicates | Excel Discussion (Misc queries) | |||
| compare two columns and remove duplicates | Excel Worksheet Functions | |||
Linear Mode
