Add Unique Values to Dictionary

Hi

I have recently discovered the dictionary object and believe it will fit my purpose.

I have list of data that I need to split out to a summary report, however, I only want the unique items.

The original list would look like this

BM01
BM01
BM02
BM01
BM03
BM01
BM03

The output should look like this:

BM01
BM02
BM03

Is there a way to only add the unique items to the dictionary?

Thanks

McC

Look here:

(Or you can use a Pivot table)

Warning: Not working with numbers.

or with dictionary

Please Login or Register  to view this content.

or with a zbor special
'=LOOKUP(REPT("Z",255),CHOOSE({1;2},"",INDEX($A$2:$A$30,MATCH(TRUE,INDEX(ISNA(MATCH($A$2:$A$30,$E$1:$E1,0)),0),0))))