تابع Unique

Note: The UNIQUE function is a new "Dynamic Array Function" in Excel. It is a beta feature

where "list" is the named range B5:B11.

Note: this is an array formula and must be entered using control + shift + enter.

([MATCH(lookup_value, lookup_array, [match_type

MATCH(0,{0;0;0;0;0;0;0},0) // 1 (Joe)
MATCH(0,{1;0;0;0;1;0;0},0) // 2 (Bob)
MATCH(0,{1;1;0;0;1;0;1},0) // 3 (Sue)
MATCH(0,{1;1;1;1;1;0;1},0) // 6 (Aya)