LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cleaning forms Lost in Microbiology Excel Discussion (Misc queries) 3 March 13th 07 07:20 PM
Cleaning data Torero Excel Worksheet Functions 3 November 28th 06 10:16 PM
Cleaning Data AMMark Excel Discussion (Misc queries) 1 October 19th 06 07:21 PM
Spreadsheet cleaning Richard Excel Discussion (Misc queries) 3 December 13th 05 03:06 PM
"Cleaning" an Excel workbook Pizza Excel Discussion (Misc queries) 6 October 26th 05 02:48 PM


All times are GMT +1. The time now is 09:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"