| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete rows if dublicate cell value in column 2
Another question
range(a1:h20000) has some data I want to delete the entire row if a value in column d apears again in other cell (row,column d) In other words delete dublicate rows compare only the value in column d |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
delete rows if dublicate cell value in column 2
gus,
Use a formula in column I: enter either formula in I1, then copy down to match your data. Sort ascending on column I and delete any rows where I is greater than 1, and you're done. If you want to keep the first instance but delete second, third, etc., use in I1: =COUNTIF($D$1:D1,D1) If you want to keep only those that occur once and only once, use in I1: =COUNTIF(DO:D,D1) HTH, Bernie Excel MVP "gus" wrote in message ... Another question range(a1:h20000) has some data I want to delete the entire row if a value in column d apears again in other cell (row,column d) In other words delete dublicate rows compare only the value in column d |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to delete rows if cell blank in column | Excel Discussion (Misc queries) | |||
| How can I insert and delete rows within a locked cell range column | Excel Worksheet Functions | |||
| i don't want to enter dublicate data in a specific column | Excel Discussion (Misc queries) | |||
| Delete all rows where Column A contains Text | Excel Worksheet Functions | |||
| How do I delete dublicate cells? | Excel Discussion (Misc queries) | |||
Linear Mode
