Extract Top 3 customer names

[mgirvin]

Dear Smartest Excelers In The World,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I want to extract the top 3 customer names with a single formula (no helper cells and no sorting data). I have come up with a formula. I am hoping that someone can see a better formula (shorter, faster calculating, etc.).<o></o>
<o></o>
Here is the data and formulas (formulas in green):<o>

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	Industry	Customer	Amount		Top	3
2	A	Acct 1119	59948.70
3	B	Acct 1910	12138.44		Industry/Customer	Customer 1	Customer 2	Customer 3	Customer 4
4	B	Acct 2516	59948.70		A	Acct 5201	Acct 1119	Acct 8375	.
5	B	Acct 3743	59948.70		B	Acct 4045	Acct 7206	Acct 2516	Acct 3743
6	B	Acct 3806	13796.14
7	B	Acct 4007	52577.10
8	B	Acct 4045	79274.82
9	A	Acct 4408	23608.90
10	A	Acct 5201	75850.20
11	B	Acct 7089	8774.80
12	B	Acct 7206	64366.50
13	A	Acct 8375	59948.70
...

</o><o>
</o>
<o></o>
<o>Formula in cell F4 is copied throughout range F4:I5:</o>
<o></o>
<o>

Excel Workbook
	F
4	Acct 5201
...

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter these manually yourself
</o>
<o></o>
<o>Any ideas how to make this ridiculous formula better?<o></o></o>

 

[Aladin Akyurek]

F4, control+shift+enter,copy across, and down:

=IFERROR(INDEX($B$2:$B$13,MATCH(LARGE(IF($A$2:$A$13=$E4,
    IF($C$2:$C$13>=LARGE(IF($A$2:$A$13=$E4,$C$2:$C$13),$F$1),
    $C$2:$C$13+(ROW($C$2:$C$13)/1000000))),
    COLUMNS($F4:F$4)),$C$2:$C$13+ROW($C$2:$C$13)/1000000,0)),"")

 

[mgirvin]

Absolutely Awesome Aladin!!!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
It was the "adding a little bit more to each number to deal with duplicates" that really helped a lot!!! Which then reduces it down to a standard "extract data with two criteria INDEX MATCH" formula with a bit added to each to deal with dups.<o></o>
<o></o>
Thank you very much for the efficient formula that robustifies quite well!<o></o>