get unique values from a range and paste

[ajm1991]

Hi I have my data in the following format:

in B8:B57 are names example: apple, banana, banana, orange, apple, orange and also "" values. The "" values are from a formula (=if(isblank(a8), "")

I'd like to get a unique list of the names in column B, in the order they appear.

so the output would be apple, banana, orange

And paste that into range C1.

Thanks!

[AlKey]

Enter array formula in C8 and copy down

Please Login or Register  to view this content.

v	B	C
7
8	apple	apple
9	banana	banana
10	banana	orange
11	orange	watermelon
12	apple
13	orange
14
15
16	apple
17
18
19	watermelon
20
21

***Array formula
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see curly braces { } appear around your formula.
If you do not CTRL+SHIFT+ENTER [I]you will get an error or a clearly incorrect a