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