Extract only items not on previous list

Ron Rosenfeld

Posts: n/a

On Tue, 9 Aug 2005 23:28:35 -0500, "Leslie Coover" wrote:

Thanks Ron, this works good

When there is an id field and an associated name field this method can
extract only the records in list 1(columns A and B) that do not appear in
list 2 (columns C and D) and then print the result in say columns G and H.
This is a big help.
Thanks,

Glad to help. Thank you for the feedback.
--ron

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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
Making pick list conditional on selection from previous pick list	Stewart	Excel Discussion (Misc queries)	1	June 27th 05 11:30 AM
named range, data validation: list non-selected items, and new added items	KR	Excel Discussion (Misc queries)	1	June 24th 05 05:21 AM
Transfer Items to a list with no duplicates	[email protected]	Excel Worksheet Functions	1	March 30th 05 10:30 PM
how can I list items in a column with totals?	andy	Excel Discussion (Misc queries)	4	February 22nd 05 08:30 PM
How do I find out what items are in one list but not in another l.	Michelle Craig	Excel Discussion (Misc queries)	2	December 22nd 04 08:32 PM

All times are GMT +1. The time now is 06:50 AM.

Menu

About Us