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

  • Thread starter Thread starter William.R.Reisen
  • Start date Start date
W

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?
 
William,

It can certainly be done in Access, but I wouldn't go
through the trouble if it's already in Excel... even in
different workbooks. In Excel, you can:
In the sheet with the Y phrases use the first available
column to do VLOOKUP (lookup_value: Y phrase, table_array:
the column with your X phrases in the other sheet /
workbook, col_index_num: 1, range_lookup: false).
Wherever the phrase exists in X you will get the phrase
again, otherwise you will get a #NA. Filter on not equal
to #N/A, delete the rows and you're done!
Caution: either way (excel or access) matching phrases
must be identical to the dot...

HTH,
Nikos
 
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.
 
Back
Top