So I have a pretty in depth task to do with excel (at least to me it is). This is for a company that reviews the shipping information for other companies. I was given 2 separate lists of companies that hold a shipping contracts with the company that checks the shipments. (confusing already I know) Anyways, one list is about 13000 lines and the other is about 11000 lines...every name on the list of 11000 is on the list of 13000 but if the name is not on the 11,000 it is irrelevant to this task. Basically each name will be given a status based on whether or not the information matches up.
as follows:
1. Addresses much match on both lists
2. Status must be know on the 13000 entry list (master list)
if both conditions are met then a TSA number in the same row must be added and highlighted in green to the 11,000 list after the name that it belongs with. If the status is know and the addresses are different then it must be added to the 11,000 list after the name it belongs with, but instead in green, and if the status is not known the same must be done but only it needs to be highlighted in red.
This already seems difficult to me, however to take it one step further, the addresses were hand typed over the years and the addresses that belong to a Name on list one may be the same as on list 2 but only slightly different
example: 123 N Miller Road --> 123 North Miller Rd. (these are the same but obviously typed differently)


Reply With Quote






