View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dellsilv dellsilv is offline
external usenet poster
 
Posts: 1
Default 2 columns w/ text data that i want to do a wildcard comparison

iN eXCEL, I HAVE 2 COLUMNS AS SUCH:

A A EXACTMATCH
A B NOMATCH
A1 1 PARTIALMATCH
IS MISS PARTIALMATCH
X NOMATCH

I need to do a wildcard comparison between column A to column B and place in
Column C the resulting match type.