Thread: IF cell=TRUE how can I delete that row in formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
  
Posts: 10,593
Default IF cell=TRUE how can I delete that row in formula
If you want to delete a row based upon a condition, that would need VBA. Is
that acceptable?

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Stanley Braverman" wrote in message
...
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"))




Reply With QuoteReply With Quote