Lists

In anticipation of a quick decisive answer, I need some assistance with lists.  

I have made a two lists of constituents, both lists manually tweeked and NOT regenerated - lets say list HBT and list LTN.  Both lists are based on our fairly imprecise post codes which is why I have had to edited the lists manually (other Australian users will no doubt understand this).   I want to get a list of addresses which does NOT include those on list HBT and list LTN - call that list Rest of TAS.   I made a third list with all Tasmanian post code, suppressing (& "not in" & "does not have") HBT & LTN.

I have tried several lists and extractions to arrive at "Rest of TAS", to no avail.  The Rest of TAS list, whether it is generated in list manager or by extraction consistently includes constituents from list HBT and list LTN and I'm at my wit's end.

HELP!!

Parents
  • Hi Darrell

    I've feel like something similar to this should work:
    Criteria to pull TAS addresses
    List DOES NOT HAVE HBT List
    List DOES NOT HAVE LTN List

    The important thing is keeping the HBT and LTN list criteria separate from eachother.

    If that isn't working for you, this could be a quick extraction. Use the HBT and LTN lists as suppressions and then pull the TAS addresses.

Reply
  • Hi Darrell

    I've feel like something similar to this should work:
    Criteria to pull TAS addresses
    List DOES NOT HAVE HBT List
    List DOES NOT HAVE LTN List

    The important thing is keeping the HBT and LTN list criteria separate from eachother.

    If that isn't working for you, this could be a quick extraction. Use the HBT and LTN lists as suppressions and then pull the TAS addresses.

Children
  • Wow. Scratch that. I haven't had my morning caffeine yet...

    If you're going the list route, having them as separate DOES NOT HAVE criteria will only exclude people if they are in both lists. So you'd want them to be together instead.

    The extraction idea should work pretty good though. That's how I would do it.

    Good luck (and apologies for Beth's morning brain jumping in a little too early!)