Skip to Content
0
Former Member
Dec 12, 2011 at 09:46 PM

Can Not understand Not Equal

25 Views

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.