| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
repeat code remove
We have a material code list in one column.many code has repeat.
We want only one code come only one times.please help Material code. 604789 604801 604801 604865 604865 604890 604893 604895 604895 604896 604896 604896 604901 604901 622992 622993 Submitted via EggHeadCafe - Software Developer Portal of Choice USING TABLE TYPE TO ELIMINATE CURSORS http://www.eggheadcafe.com/tutorials...-to-elimi.aspx |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
repeat code remove
Assume that you are having the above mentioned values in Column A and A1 cell
is having the Column heading "Material Code" and your data is starting from A2 cell. Paste this formula in B2 cell. =IF(COUNTIF($A$2:$A2,$A2)=1,"ACTUAL",IF(COUNTIF($A $2:$A2,$A2)1,"DUPLICATE","")) Copy the B2 cell and paste it to the remaining cells of B Column based on the A Column data. Apply filter for the B column and select Duplicates. -------------------- (Ms-Exl-Learner) -------------------- "AMIT BHOPAL" wrote: We have a material code list in one column.many code has repeat. We want only one code come only one times.please help Material code. 604789 604801 604801 604865 604865 604890 604893 604895 604895 604896 604896 604896 604901 604901 622992 622993 Submitted via EggHeadCafe - Software Developer Portal of Choice USING TABLE TYPE TO ELIMINATE CURSORS http://www.eggheadcafe.com/tutorials...-to-elimi.aspx . |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
repeat code remove
On Dec 25, 12:34*pm, AMIT BHOPAL wrote:
We have a material code list in one column.many code has repeat. We want only one code come only one times.please help Material code. 604789 604801 604801 604865 604865 604890 604893 604895 604895 604896 604896 604896 604901 604901 622992 622993 Submitted via EggHeadCafe - Software Developer Portal of Choice USING TABLE TYPE TO ELIMINATE CURSORShttp://www.eggheadcafe.com/tutorials/aspnet/56ad2755-d960-4859-8bcc-7... You can use pivot table for limit only one code and can refresh when you put the new material code list in same column Hope that it can help. -------------- Worawat |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
repeat code remove
Try using Advanced filter.
Select all of the data including column header. Select Data - Advanced Filter Check Unique records box. Please yourself whether you filter in place or copy to another location. If you filter in place then the unwanted duplicate rows are hidden. If you copy to a new location, the original list remains unchanged and the new list is unique records only. -- Regards, OssieMac "AMIT BHOPAL" wrote: We have a material code list in one column.many code has repeat. We want only one code come only one times.please help Material code. 604789 604801 604801 604865 604865 604890 604893 604895 604895 604896 604896 604896 604901 604901 622992 622993 Submitted via EggHeadCafe - Software Developer Portal of Choice USING TABLE TYPE TO ELIMINATE CURSORS http://www.eggheadcafe.com/tutorials...-to-elimi.aspx . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| incorporate the remove #DIV/0! code into another formula to get bl | New Users to Excel | |||
| code to remove rows containing a character string | Excel Discussion (Misc queries) | |||
| Remove Cell Color after Code is Deleted | Excel Discussion (Misc queries) | |||
| VBA Code To have a macro repeat on all sheets in a workbook | Excel Worksheet Functions | |||
| Repeat Code Repetitive Actions? | Excel Discussion (Misc queries) | |||
Hybrid Mode
