| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Delete rows in a column
I have the following data in Columns A and B. I would like to write code for
all rows in columns A and B that: delete the rows for Example1 since the values in Column B are the same delete the row for Example 2 since it only has one value keep the rows for Example 3 since the values in Column B are NOT unique delete the rows for Example 4 since the value in Column B are the same Column A ColumnB Example1 Create PO Example1 Create PO Example1 Create PO Example2 Create PO Example3 Approve Invoices Example3 Approve Invoices Example3 Create PO Example4 Approve Invoices Example4 Approve Invoices Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete Rows Where Value in Column V is Less than 2.5? | Excel Programming | |||
| Delete rows with nothing in Column B | Excel Programming | |||
| delete rows if value in column D is repeated | Excel Programming | |||
| Delete all rows where Column A contains Text | Excel Worksheet Functions | |||
| Delete All Rows That Column A value is not in Column A of Sheet2 | Excel Programming | |||
Threaded Mode
