List unique customers in column A whose region in B is East and status in C is Active

公式

=UNIQUE(FILTER(A2:A500, (B2:B500="East")*(C2:C500="Active")))

说明

FILTER keeps rows that pass both tests. UNIQUE then drops repeated customers. Excel 365 / 2021 required; older Excel should use a helper column or the generator’s 2016 platform.

步骤

  1. Boolean products implement AND inside FILTER.
  2. FILTER returns matching names (with duplicates).
  3. UNIQUE collapses the spill to distinct customers.

变体

OR across regions

Adding two region tests implements OR.

=UNIQUE(FILTER(A2:A500, ((B2:B500="East")+(B2:B500="West"))*(C2:C500="Active")))

Sort the result

Alphabetical drop-down source.

=SORT(UNIQUE(FILTER(A2:A500, (B2:B500="East")*(C2:C500="Active"))))

Return several columns

Spills name, region, and status together.

=UNIQUE(FILTER(A2:C500, (B2:B500="East")*(C2:C500="Active")))