Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cleaning forms | Excel Discussion (Misc queries) | |||
Cleaning data | Excel Worksheet Functions | |||
Cleaning Data | Excel Discussion (Misc queries) | |||
Spreadsheet cleaning | Excel Discussion (Misc queries) | |||
"Cleaning" an Excel workbook | Excel Discussion (Misc queries) |