List Subsets?!

[wings1080]

Hi All,

I have 2 files of coordinate information let's call it list A and list B, each file has 3 columns for Easting, Northing and Elevation. List A has 14,530 points and list B has 20,087 points.

First I have to make sure that EVERY POINT in list A is ALSO in list B, meaning, if there are some points in list A that are NOT in list B, I need that list .... THEN, once that is done I then need a list that is all the points in list B that are NOT ALSO in list A, headache starting now ...

Please HELP!

 

[isabelle]

hi,

suppose list A in on Sheet1 and list B is on Sheet2
copy the following Array formula in cell D2, validate array formula with
ctrl + shift + enter then fill down

=MATCH(Sheet2!A1&Sheet2!B1&Sheet2!C1,Sheet2!A:A&Sheet2!B:B&Sheet2!C:C,0)

isabelle

Le 2013-09-05 17:36, (e-mail address removed) a écrit :

Hi All,

I have 2 files of coordinate information let's call it list A and list B,

each file has 3 columns for Easting, Northing and Elevation. List A has
14,530 points and list B has 20,087 points.

First I have to make sure that EVERY POINT in list A is ALSO in list B, meaning,

if there are some points in list A that are NOT in list B, I need that
list .... THEN, once that is done

I then need a list that is all the points in list B that are NOT ALSO in
list A, headache starting now ...

 

[isabelle]

oops,

copy the following Array formula in cell D1

isabelle

Le 2013-09-05 18:30, isabelle a écrit :