Match like cells and return the latest date

  • Thread starter Thread starter confused!!
  • Start date Start date
C

confused!!

FIRST scenario:
I have three columns of data. Column A and B are similar with two
exceptions (i)column A is preceeded by two more identifying characters than
in column B (ii) Column B is a partial listing of column A. Column C has a
complete listing of Full names that needs to be matched with the partial list
in column B.

Example:
Column A Column B Column C
CLMoton Moton Cleveland

objective is to match Moton to Cleveland based on column A.

My thought was to search by a "LIKE" function or macro. is there such a
thing?
 
I think you need to give more than one example of your data. Also,
please explain more fully what you are starting with and what you want
to achieve from it.

Pete
 
Back
Top