SQLScholar
Programmer
hey
I have 2 lists of company names which i need to cross reference to see what who is on both. I have a slight problem though. An example (no real world companies) is below.
Sheet 1
ABC PLC
tek-tips
Me plc
antoher example
here group
sheet 2
A.B.C PLC
tech-tips
me
another example
here
Now basically what i want i to be able to pick up as many of these as possible (a human would match probably all of em), but with the use of office (prob excel). All of the customer will not be on both sheets - i basically have a sheet, and i want to be told what ones are on the other sheet aswell.
But there seems to be too many of this style of problem. If anyone has a solution which would solve any of the above problems (and more importantly not effect other ones picking up wrongly) please post
I know its a tall order to solve em all, but any help on any of them is very much appreciated.
Thanks in advance
Dan
----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!
I have 2 lists of company names which i need to cross reference to see what who is on both. I have a slight problem though. An example (no real world companies) is below.
Sheet 1
ABC PLC
tek-tips
Me plc
antoher example
here group
sheet 2
A.B.C PLC
tech-tips
me
another example
here
Now basically what i want i to be able to pick up as many of these as possible (a human would match probably all of em), but with the use of office (prob excel). All of the customer will not be on both sheets - i basically have a sheet, and i want to be told what ones are on the other sheet aswell.
But there seems to be too many of this style of problem. If anyone has a solution which would solve any of the above problems (and more importantly not effect other ones picking up wrongly) please post
I know its a tall order to solve em all, but any help on any of them is very much appreciated.
Thanks in advance
Dan
----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!