If statement

[jaypatel]

Hi,

I have 2 columns A and B of course.....

I need a script that would do the following:

If a3=a2 and b3=b2 then delete row
if a3=a2 and b3>b2 then delete row b2
if a3>a2 then keep row a2..... in a kind of loop effect.

Any help would be appreciated.

Regards

Jay

 

[Scott Huish]

Duplicate post:

See: http://www.mrexcel.com/board2/viewtopic.php?p=1128197