| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Cells with Duplicates
Hello,
I have two columns with numbers. I want to delete cells in both columns if the data is matched. Here's an example Column A is Amount1 and Column B is Amount2 Amount1 Amount2 35 1 48 18 21 26 12 48 16 3 39 4 2 21 0.5 13 If the amount exists in column a and b then I want both cells to be deleted in both columns. Thanks for the help. Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting Duplicates | Excel Discussion (Misc queries) | |||
| Finding/deleting duplicates and merging cells | Excel Worksheet Functions | |||
| Deleting the first row of two duplicates. | Excel Discussion (Misc queries) | |||
| Deleting duplicates | Excel Programming | |||
| Deleting Duplicates | Excel Programming | |||
Threaded Mode
