Hi
I want to delete the rows that has 1 or 2.. I mean :
AB---CD--EF-
12....00...00....00 This row must be removed because it has 1 in col A and 2 in col B
00....11...22....11 This row mustnt be removed because it doesnt have 1 and 2 side by side
or let me put it that way
If ((a1=1 and b1=2) and (a1=2 and b1=1),and (c1=1 and d1=2) and( c1=2 and d1=1)......range up to Column "F"...."delete")
please have a look at the attachment file.
Thanks
Bookmarks