Extract a unique list of items with formula2

[GerryZ]

Hi all!!
you can se on the top table the data base
on the bottom table i need to extract unique names based on the fruit criteria
let me know
tahnk you in advance!

Excel Workbook
	A	B	C	D	E
1	FRANK	GEORGE	JULIE	MIKAEL	LUIS
2	APPLE	KIWI	APPLE	TANGERINE	KIWI
3	ORANGE	ORANGE	KIWI	TANGERINE	PEAR
4	ORANGE	ORANGE	ORANGE	TANGERINE	PEAR
5	APPLE	ORANGE	ORANGE	ORANGE	PEAR
6	PEAR	ORANGE	ORANGE	ORANGE	KIWI
7	PEAR	ORANGE	ORANGE	ORANGE	KIWI
8		KIWI
9
10
11	RESULT
12	APPLE	ORANGE	PEAR	KIWI	TANGERINE
13	FRANK	FRANK	FRANK	GEORGE	MIKAEL
14	JULIE	GEORGE	LUIS	JULIE
15		JULIE		LUIS
16		MIKAEL
17
Sheet

 

[hiker95]

GerryZ,

Thank you for the answer

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.

i'm really far from VBA

If you do find that you would like to learn VBA, then:

See if something, in the below links, of my most up to date list will help you:

Training / Books / Sites as of 11/22/2014

http://www.mrexcel.com/forum/genera...ns/820920-how-we-learn-excel.html#post4006402