470,561 Members | 1,906 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,561 developers. It's quick & easy.

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

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?
Nov 12 '05 #1
1 1552
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?


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

14 posts views Thread by Sean C. | last post: by
6 posts views Thread by Peter Frost | last post: by
49 posts views Thread by Yannick Turgeon | last post: by
4 posts views Thread by alexandre.brisebois | last post: by
1 post views Thread by Chris | last post: by
1 post views Thread by livre | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.