I have to sort through over a million cells of data. I have two sources I had to get this data from and combine it into on excel sheet. One of the data has a list of all the airplanes that are currently owned in the US. Included is the address where the airplane owner resides. The name of the owner is not on this list. The other data sheet has a list of the active pilots in the US. Included is their full name and address where they reside. My goal is to match the pilots with their planes. To do that I combined both sources of data into one excel sheet and then sorted it based on address. This gave me a very long list of all the pilot and plane addresses next to each other. It is now my job to sort through it and highlight the plane and pilot whose address match each other. From there I can filter the data based on color and have a list of all the pilots who own planes. This takes very long. Is there a better way to do this?
Please note things I have tried:
I've tried to use "conditional formatting" -> "Highlighting Cell Rules" -> "Duplicate Values"
This worked but only picked up on the duplicate value from the same imported worksheet. It didn't pick up on the two cells from the two different imported worksheets of pilot and airplanes. I've tried to reformat all the cells to be the same and then repeat the above steps but it still didn't work.
Thank you for your time,
Joe
Please note things I have tried:
I've tried to use "conditional formatting" -> "Highlighting Cell Rules" -> "Duplicate Values"
This worked but only picked up on the duplicate value from the same imported worksheet. It didn't pick up on the two cells from the two different imported worksheets of pilot and airplanes. I've tried to reformat all the cells to be the same and then repeat the above steps but it still didn't work.
Thank you for your time,
Joe