How to search for contacts who appear in multiple smart groups

[The Doctor]

This is probably really obvious, but I am not seeing it.

I have a number of smart groups set up. I want to find the contacts who appear in two or more of these groups. In other words I want to search for contacts who appear in BOTH Group A AND Group B, for example.

One use for this is with smart groups based on membership status. I want to be able to find those contacts who have BOTH active memberships (Current or New status) AND inactive memberships (Expired status).

How can I do this?

Any help appreciated.

[JonGold]

The bad news is that this is a bit of a pain point in CiviCRM.  The good news is that there's a solution specifically to address your problem.  Go to Search menu > Custom Searches (it's the last option), and use the "Include/Exclude Groups" custom search.

All that said - in your specific use case, you could create a new smart group of folks who have active and inactive memberships.

[The Doctor]

Thanks for replying JonGold.

As far as I can tell, both of those suggestion allow me to find people who are in one or the other group.

The Include/Exclude search seems to be boolean A OR B. I need A AND B.  In other words, If I put two groups into the Include field, the result is a list of people who are in one or both of the groups. I only want to find the people who are in both of the groups.

The same is true of a membership search where I check off both Current and Expired status. I get people with either Current or Expired status.

Or am I missing something?

[JonGold]

Sorry, you're right.  My memory was incorrect about what the radio buttons on that custom search did.

Fortunately, there's a simpler answer, which is the Search Builder.  Note that searching for groups was a bit wonky pre-4.5, so if you have a problem, you may need an upgrade, but I just tested this on 4.5.2:
Search Builder:
Group = Group 1
Group = Group 2

[The Doctor]

Aha! That works. Thank you so much!