Help with cleaning up a workbook.
Assuming data in both worksheets is in column A starting row 2:
In B2 of sheet A:
=Countif(SheettB!B2:B100,A2)
copy down to end of column A list
Filter on column B=1 and delete these rows
P.S It's A-B according to your results.
"Dolphy" wrote:
Hi All,
I have two documents, one is the master (A) list and the other is the
used (B) list.
I want to remove data from the used list (B). In effect it will be B -
A.
All of the data I have is numerical.
For example:
Worksheet A would have:
04121
04122
04123
04124
04125
04126
04127
04128
Worksheet B would have:
04122
04124
04125
04128
The result would be:
04121
04123
04126
04127
Is there an easy way of doing this in Excel?
Rgds,
Dolphy
|