Excel多列过滤：如何按多兴趣列筛选邮件联系人列表

Absolutely! This is a super common use case and totally achievable with most tools you’d use to manage contact lists—whether that’s a spreadsheet or an email marketing platform. Let me break down how to do this in the most common scenarios:

For Spreadsheets (Excel/Google Sheets) #

If you’re managing your contacts in a spreadsheet, you have two reliable options:

• Dynamic Formula Method (best for auto-updating lists):
  Use the FILTER function with an OR condition. Let’s say your contact data is in columns A (Name), B (Food Interest), C (Culture Interest). The formula would be:

  =FILTER(A:C, (B:B="Yes")+(C:C="Yes")>0)
  

  The + acts as an OR operator here—if either column has "Yes", the sum will be 1 or higher, so the row gets included in the filtered results. This works the same in both Excel and Google Sheets.
• Manual Filter Feature:
  Go to the Data menu, select Filter, then click the dropdown arrow in either the Food or Culture column. Check the "Yes" box, and repeat for the other column (most spreadsheets will keep rows that match either filter automatically).

For Email Marketing Platforms #

If you’re using a tool like Mailchimp, Constant Contact, or HubSpot to manage your email list:

• Navigate to the segmenting or list filtering feature.
• Create a new segment with two conditions:
  1. "Food Interest" equals "Yes"
  2. "Culture Interest" equals "Yes"
• Set the logic between these conditions to OR (not AND). This will pull every contact that meets either of the criteria, exactly what you need.

Either way, this will perfectly match your requirement—any entry where either the Food or Culture interest is marked "Yes" (like your example rows 2 and 3) will be included in your final list.

内容的提问来源于stack exchange，提问作者McKeene