Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compareing 2 columns
Hi
I would like to compare 2 columns values. the "+1" is still value. For example there are 1406 in column A and 14061 in column B in this case the whole row should be deleted from the workbook. Is there a way to do it with a macro? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
compareing 2 columns
Could you repeat the question? It's not clear what you're asking for.
Ross "tomi12619" <tomi12619@laptop wrote in message ... Hi I would like to compare 2 columns values. the "+1" is still value. For example there are 1406 in column A and 14061 in column B in this case the whole row should be deleted from the workbook. Is there a way to do it with a macro? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
compareing 2 columns
There are IDs on column A like 1406 or 1412. In column B, there are other values made from the IDs with +1 prefix, like 14061 or 14121. These are logically equal. sometimes in column B there are other numbers.
I would like to clean the table with deleteing the rows containing the "A=1406 = B=14061" values. Could you repeat the question? It's not clear what you're asking for. Ross "tomi12619" <tomi12619@laptop wrote in message ... Hi I would like to compare 2 columns values. the "+1" is still value. For example there are 1406 in column A and 14061 in column B in this case the whole row should be deleted from the workbook. Is there a way to do it with a macro? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compareing 2 columns | Excel Worksheet Functions | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
Compareing 2 Worksheets in different workbooks | Excel Programming |