Spill a unique list of emails from column A, keeping original order

公式

=UNIQUE(FILTER(A2:A500, A2:A500<>""))

说明

UNIQUE keeps the first occurrence of each value. FILTER drops blanks so they do not count as a duplicate group.

步骤

  1. Point UNIQUE at the source column.
  2. FILTER out empty cells first.
  3. The result spills downward automatically in Excel 365.

变体

Unique by two columns

A row is unique when the A+B pair has not appeared before.

=UNIQUE(A2:B500)

Distinct values sorted

Alphabetical unique list for drop-downs.

=SORT(UNIQUE(FILTER(A2:A500, A2:A500<>"")))

Excel 2016 helper

Copy down. First occurrence stays; later duplicates go blank. Then filter non-blanks.

=IF(COUNTIF($A$2:A2, A2)=1, A2, "")