compareing 2 columns
I does not work properly. In column B I have the +1 values such as
1406 14061
1407 14071
but sometimes wrong things like
1408 1408
1408 .C
You could enter a formula like this in C1:
=IF(A1=B1,"ok","delete")
and then copy down for as many values as you have. Then use Data |
Filter | Autofilter, and on the drop-down in column C select "delete".
Highlight all the visible rows and click on Edit | Delete Row. Remove
the filters and delete column C.
Hope this helps.
Pete
On Oct 9, 10:40 pm, "tomi12619" <tomi12619@laptop wrote:
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?
|