Hi,
In one Excel spreadsheet, I have Tab A and Tab B
Tab A has IP Addresses
Tab B has IP Addresses
There are about 5100 records on Tab A
There are about 800 records on Tab B
I just want a report with the IP Addresses that do not match between Tab A and Tab.
I tried doing a join (not sure if it should be inner join, left outer join or a right outer join /enforced / not enforced).
I tried doing select records on: Tab A IP Address <> Tab B IP Address
I was getting like 10,000 records? I have been trying to figure this out for a few hours.
This is so confusing.... can someone please shed some light.