Help with cleaning up a workbook.
 

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

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