Find two highest values and index (even value is the same)

[diilmac]

Hello

I tried many combinations of formulas but every time first and second highest value is the same im getting first key for both.

DATA
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]#[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]USER1[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2[/TD]
[TD]USER1[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]3[/TD]
[TD]USER1[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]4[/TD]
[TD]USER2[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]


Display
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]#[/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][find key [DATA A:A] of first highest value [DATA C:C] based on [Display B3][/TD]
[TD]USER1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][find key [DATA A:A] of second highest value(even is the same as first one) [DATA C:C] based on [Display B3][/TD]
[TD]USER1[/TD]
[/TR]
</tbody>[/TABLE]

 

[AhoyNC]

Try:
Copy formulas down as needed.

Excel Workbook
	A	B	C
1	1	USER1	8
2	2	USER1	8
3	3	USER1	4
4	4	USER2	5
5
6
7
8
9	1	USER1
10	2	USER1
Sheet

 

[AhoyNC]

In my post above formula in A9 doesn't need to be enter as an array (just ENTER will work).

 

[diilmac]

Thank you AhoyNC for quick answer, but this is not exactly what Im looking for.
Let me explain one more time

[TABLE="class: grid, width: 500"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] "]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]USER1[/TD]
[TD="align: center"]8[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]2[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]USER1[/TD]
[TD="align: center"]8[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]3[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]USER1[/TD]
[TD="align: center"]4[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]4[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]USER2[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]5[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]USER3[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]6[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]USER2[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]7[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]USER4[/TD]
[TD="align: center"]7[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]8[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]USER3[/TD]
[TD="align: center"]9[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]9[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]USER4[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]10[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]USER2[/TD]
[TD="align: center"]11[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]11[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]USER3[/TD]
[TD="align: center"]12[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]13[/TD]
[TD][key (A column) of first highest value (C column) based on B13][/TD]
[TD]USER1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]14[/TD]
[TD][key (A column) of second highest value (C column) based on B14][/TD]
[TD]USER1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]15[/TD]
[TD][key (A column) of first highest value (C column) based on B15][/TD]
[TD]USER2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]16[/TD]
[TD][key (A column) of second highest value (C column) based on B16][/TD]
[TD]USER2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]17[/TD]
[TD][key (A column) of first highest value (C column) based on B17][/TD]
[TD]USER3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CACACA]#CACACA[/URL] , align: center"]18[/TD]
[TD][key (A column) of first highest value (C column) based on B18][/TD]
[TD]USER3[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Basically I need to find only key, B13:B18 will be fixed value

 

[AhoyNC]

Try:
This is an array formula that must be entered with CTRL-SHIFT-ENTER. Drag formula down as needed.

Excel Workbook
	A	B	C
1	1	USER1	8
2	2	USER1	8
3	3	USER1	4
4	4	USER2	5
5	5	USER3	1
6	6	USER2	3
7	7	USER4	7
8	8	USER3	9
9	9	USER4	2
10	10	USER2	11
11	11	USER3	12
12
13		USER1	1
14		USER1	2
15		USER2	10
16		USER2	4
17		USER3	11
18		USER3	8
Sheet

 

[diilmac]

This is exactly what I need, Thank you so much AhoyNC