Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2007

Tip: Looking for answers? Try searching our database.

How to creat new list by subtraction

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Maggie - 29 Aug 2007 19:21 GMT
Hello All,

I'm new to Excell 2007 from Quattro Pro. I have two
spread sheet mailing lists: (1) Master list. (2) Recently
Mailed list (subset of master list).  I would like to
subtract-out (consolidate by removal) the recently
mailed list from the Master list, leaving me with a new
list of yet-to-be-mailed names.  How you Excell fokes
do that?

Many thanks,

Maggie
Max - 30 Aug 2007 00:44 GMT
One play which can deliver this ..

Assume source lists are in identically structured sheets: Master, Subset
in cols A and B, data from row1 down, with key col = col A (eg: unique ID
#s)

In another sheet, titled: Balance (say)

In A1:
=IF(Master!A1="","",IF(ISNUMBER(MATCH(Master!A1,Subset!A:A,0)),"",ROW()))

In B1:
=IF(ROW()>COUNT($A:$A),"",INDEX(Master!A:A,SMALL($A:$A,ROW())))

Copy B1 to C1 (as there 2 cols of source data. Just copy across by as many
cols). Then select A1:C1, copy down to cover the max extent of data expected
in Master. Hide away col A. Cols B to C will return the required "balance"
list ie lines in Master not in Subset, with all results neatly bunched at
the top.
Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Hello All,
>
[quoted text clipped - 9 lines]
>
> Maggie
Maggie - 31 Aug 2007 20:41 GMT
> One play which can deliver this ..
>
> Assume source lists are in identically structured sheets: Master, Subset
> in cols A and B, data from row1 down, with key col = col A (eg: unique ID
> #s)

Yes, "identically structured sheets"

> In another sheet, titled: Balance (say)
>
[quoted text clipped - 9 lines]
> "balance" list ie lines in Master not in Subset, with all results neatly
> bunched at the top.
Cool, will give it a go.

Thanks Max! :-)
Max - 01 Sep 2007 02:20 GMT
welcome. it should work fine.
Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Cool, will give it a go.
>
> Thanks Max! :-)

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.