I don’t know if this needs to be done in access or excel…I have three lists of numbers all six digits long. The lists are all various lengths. I would like to compare list one to two and see which numbers are similar in each list. And then I would like to compare list three to one and do the same. And if this is not too complicated I would like to compare list two to three.
If my description is a little vague here is a little more specific explanation. I have three computer applications that are not integrated however they are using the same six digit code. I want to compare the codes in each and see which codes are similar between all three.
I know should be an easy way to do this in either access or excel but I can’t think of it. I have attached a copy of the numbers in case that helps. Thank you in advance.