View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
via135 via OfficeKB.com via135 via OfficeKB.com is offline
external usenet poster
 
Posts: 30
Default matching columns using text strings!

hi!

i am having text data thru A1:B6

col A ...............col B
john ambrose....ambrose j
edmond c.........c edmon
arthur a............morais p
w peter william..peter
williams john.....w john
ambrose...........rose j

i need to compare the lists and shortlist the rows
having the unmatched columns with some flag in col C.

the criteria is if some text string *minimum with 5 characters*
in either column should be matched with the other column!

thus the result should be as under:

arthur a..................morais p
ambrose.................rose j

hope that explained the things well!

any help pl?

-via135

--
Message posted via http://www.officekb.com