If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Delete BOTH sets duplicate data in columns (debits/credits)
Constance,
Insert a column between A and B. In the new cell B1, enter the formula =ISERROR(MATCH(A1,C:C,False)) Copy down to match column A. The formula will be TRUE if the value in A1 does not appear in C (the old B) and FALSE if it does. Then in D1, enter the formula =ISERROR(MATCH(C1,A:A,False)) Copy down to match column C. Convert both formula columns to values, then sort A:B based on B and delete the values in A and B where B is FALSE, and sort C based on D and delete the values in C and D where D is FALSE. HTH, Bernie MS Excel MVP "Iamconstance" wrote in message ... 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 | |
Display Modes | |
|
|