| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Delete BOTH sets duplicate data in columns (debits/credits)
I am trying to find out how to delete BOTH sets of data in a column when
there is not a unique entry. For example if I have a 10 in cell A1 and a 10 in cell B5 I would like them BOTH to be removed, leaving me with only values in Cell A that have no match anywhere in Cell B. Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to FIND DUPLICATE DEBIT AND CREDITS | Excel Worksheet Functions | |||
| Using Sumif with debits & credits | Excel Discussion (Misc queries) | |||
| vertical lines between credits and debits | New Users to Excel | |||
| formula for debits and credits in EXCEL spreadsheet | Excel Worksheet Functions | |||
| How do I delete both sets of duplicate data? | Excel Discussion (Misc queries) | |||
Threaded Mode
