Xcel or Access sort columns of names so that I remove the intersect between 2 columns from one of the columns?

[William.R.Reisen]

Hi,

I have currently in Xcel and long list of X English phrases in one
column with associated numerical data about each name in adjoining
columns.

I have on another workbook (which could of course be pasted into this
workbook)another similarly set out column of Y English phrases again
with ajoining columns having numberical data row that the phrase.

I would like to be able to sort the second column of phrases removing
all the phrases that occured in the first column. Ideally it would be
great to have the numerical data for the remaining English phrases
still on the same rows (not necessary though)

In math terminology I want to find:
(Remaining phrases)=(Y English Phrases)-(X English Phrases)

The data is currently in Xcel. How would I do this? Would I be better
off in Access or doing it by hand and eye?

[Salad]

If I were doing it from Access, I'd do a File/GetExternalDatabase/Link
(or import if you wanted to make a table), select the file, then select
the worksheet. Then do that for the next worksheet. You now have 2
tables you can use to compare. Create a query via the New button. You
can select records that match via Design view. You can also create find
unmatched record queries between the two tables. If you link them, if
you delete or change in Access, the records will be updated in Excel. If
you make tables via importing, then your data in Excel will not be
updated.

"William.R.Reisen" wrote:

Hi,

I have currently in Xcel and long list of X English phrases in one
column with associated numerical data about each name in adjoining
columns.

I have on another workbook (which could of course be pasted into this
workbook)another similarly set out column of Y English phrases again
with ajoining columns having numberical data row that the phrase.

I would like to be able to sort the second column of phrases removing
all the phrases that occured in the first column. Ideally it would be
great to have the numerical data for the remaining English phrases
still on the same rows (not necessary though)

In math terminology I want to find:
(Remaining phrases)=(Y English Phrases)-(X English Phrases)

The data is currently in Xcel. How would I do this? Would I be better
off in Access or doing it by hand and eye?