fill an array with unique values based on criteria

[biubiubiu]

Hi All

I need to extract unique values based on specific criteria to use for other procedure ,

for example, for the chart below (illustration only, not actual data), I would need to extract the string (A,C)



List

	Criteria
A	0
A	0
A	1
B	0
B	0
C	1
C	1

<tbody>
</tbody>

Currently I have no idea how should I tell excel to do both:
1) extract only Unique values to an array (i.e. examples above I only want "A,C" not "A,C,C")

2) fill values to an array based on criteria from adjacent column


any help is appreciated

Thanks

 

[WarfritLive]

How about
=SUMPRODUCT(1/COUNTIF(A:A,A:A),--(B:B=1))

It will only return one per unique value in column (It actually splits them up and recombines them after), then it adds the column B stuff