Hi,
I have two looooong lists with some client info that need to be compaired.
The two lists are now combined based on a client number, so I want to compare that the cilent name is the same in two cells next to each other. Problem is that one list says "Company A" the other "Company A, invoice adress". I want to know if the first part of the string is the same.
I guess I need to use some kind of wild card.
Example of list:
Company A______Company A, Invoice adress_____True
Company B______Company X, Invoice adress_____False
Company C______Company C, Invoice adress_____True
The output does not have to be true/false, it could be 1/0 or anything just easy to spot the difference or sort on later
Bookmarks