Thread: Macro analyses cells in 2 columns . If same text found , keeps row
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrei Andrei is offline
external usenet poster
  
Posts: 53
Default Macro analyses cells in 2 columns . If same text found , keeps row
I need a macro which analyses 2 columns (say B and D) . If same text is found
both in cell B1 and D1 (and so on) , keeps the row . If not , it delets the
row .

Same text meaning 1-5 words which should be the same except capitalisation
which should not matter
Reply With QuoteReply With Quote