| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
