data|Filter|autofilter works perfectly. Thanks for that easy
solution!!!!!!

"Dave Peterson" wrote in message
...
Maybe you can apply data|Filter|autofilter to show only the rows you want
to
delete.

Then you can delete those visible rows.



Stanley Braverman wrote:

I am using this code to test for near duplicate entries but can not auto
delete row that tests OK or TRUE

=IF(MID(A2,1,5)=MID(A3,1,5),IF(MID(B2,1,8)=MID(B3, 1,8),"OK","NOT OK"))

--

Dave Peterson