View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Trumpet Trumpet is offline
external usenet poster
 
Posts: 4
Default comparing two columns for partial values

What I want is that I create one formula and paste it in all the 500 cells.
the formula will search in every cell of column A to find a partial match in
column B