Unique in Range

[How_Do_I]

Hello, how would I count the unique in a range like this and extract them in to a vertical list please...?

Excel Workbook
	B	C	D	E
2	Plum
3	Plum	Watermelon	Apple	Peach
4	Melon	Kiwifruit		Blackberry
5	Raspberry	Blueberry	Cranberry	Banana
Sheet1

 

[navic]

You should, open a new thread of your own.
Try

=IFERROR(INDIRECT(TEXT(AGGREGATE(15,6,(ROW(B$2:I$18)*10^6+COLUMN(B$2:I$18))/((B$2:I$18<>"")*(ISNA(MATCH(B$2:I$18,L$1:L1,0)))),1),"R000000C000000"),0),"")

 

[gianvi]

You should, open a new thread of your own.
Try

=IFERROR(INDIRECT(TEXT(AGGREGATE(15,6,(ROW(B$2:I$18)*10^6+COLUMN(B$2:I$18))/((B$2:I$18<>"")*(ISNA(MATCH(B$2:I$18,L$1:L1,0)))),1),"R000000C000000"),0),"")

ok, tks for your suggestion.
i've opened a new thread
this the formula i used but not working for me on excel 2016, result is 0