Extract unique list of name in order from the larger from a table multiple columns

Hello excel gurus I'm back
this is a little screen shot from my very big sheet
As you can see I need two formulas

1) in E3 the list of unique names from the top player until the small player
2) In F3 the count of times the name is displayed

Thank you so much for yur help

	A	B	C	D	E	F
1					Result
2	Joe	Mikael	Franz		Name	Times
3	Luis	Joe	Luis		Luis	4
4	Luis				Joe	3
5	Franz				Franz	2
6					Anna	2
7	Anna	Mike	Joe		Mikael	1
8	Luis	Anna			Mike	1

Copy the data from columns A2:C8, 1 column at a time, and paste them all into column E, so that you have 1 column with 21 names (including blanks).

Then use the 'Remove Duplicates' tool from the data tab on the excel ribbon.

Delete the blank (shift cells up).

Enter the count formula into F3

=COUNTIF(A:C,E3)

Use this CSE formula in E3, and drag down:

=IFERROR(IFERROR(IFERROR(INDEX($A$2:$A$10,MATCH(0,COUNTIF($E$2:E2,$A$2:$A$10)+($A$2:$A$10=""),0)),INDEX($B$2:$B$10,MATCH(0,COUNTIF($E$2:E2,$B$2:$B$10)+($B$2:$B$10=""),0))),INDEX($C$2:$C$10,MATCH(0,COUNTIF($E$2:E2,$C$2:$C$10)+($C$2:$C$10=""),0))),"")

and in F3 use this (normal) formula:

=COUNTIF($A$2:$C$10,E3)

double post

Thank you every body for the answer

@jason I prefer a formula mathod

@ Indy Your formula works but i prefer the unique list from the top name

I'm thinking maybe is better helper columns? with al name and extract from larger number I'm confuse not sure
Thank you for your help

There are several methods suggested in this thread.

http://www.excelforum.com/excel-form...le-column.html

Are any of them acceptable?