I have a data set that contains Date Worked (A), Transaction Text (B), Hours
(C), Value (D)

Unfortunatley, the Transaction Text contains the names of the employees and
are not always the same.

However, some part of the Transaction Text always contains the surname but
may be in a different location in the string. An example is "a cole - to
stores" and "a cole - fabricate basket".

I had thought to create a control list (surnames), then use sumproduct to
find the the control text within the free text descriptions and then
calculate the sum of the values and hours for a range of dates (pay periods)
for each match.

We have since given each person a unique code to search on. However, this is
historical data that I can't change without updating thousands of records.

Any solution would be gratefully appreciated.

Jim
--
Jim