View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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