| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete dupes in column
All,
I have a worksheet with < 200 rows of data (6 Cols). I need to eliminate the entire row of data if Column "B" contains any duplicate entries. I prefer using VBA, as the rest of the project uses it almost exclusively. I have tried looping thru the entire table for each new value in the column, but it takes much too long and results in buffer overruns. Thanks, BigRog |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy column header to next column, delete & delete every nth colum | New Users to Excel | |||
| vlookup & sum? or maybe summing dupes? | Excel Discussion (Misc queries) | |||
| macro for dupes | Excel Discussion (Misc queries) | |||
| Checking for Dupes | Excel Discussion (Misc queries) | |||
| How can I check for dupes in more than one column in excel? | Excel Worksheet Functions | |||
Threaded Mode
