Thread: IF cell=TRUE how can I delete that row in formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stanley Braverman Stanley Braverman is offline
external usenet poster
  
Posts: 40
Default IF cell=TRUE how can I delete that row in formula
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