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

diilmac

New Member
Joined
Apr 17, 2019
Messages
4
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
#ABC
11USER18
22USER18
33USER14
44USER25

<tbody>
</tbody>


Display
#AB
1[find key [DATA A:A] of first highest value [DATA C:C] based on [Display B3]USER1
2[find key [DATA A:A] of second highest value(even is the same as first one) [DATA C:C] based on [Display B3]USER1

<tbody>
</tbody>
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Try:
Copy formulas down as needed.
Excel Workbook
ABC
11USER18
22USER18
33USER14
44USER25
5
6
7
8
91USER1
102USER1
Sheet
 
Upvote 0
In my post above formula in A9 doesn't need to be enter as an array (just ENTER will work).
 
Upvote 0
Thank you AhoyNC for quick answer, but this is not exactly what Im looking for.
Let me explain one more time

ABC
11USER18
22USER18
33USER14
44USER25
55USER31
66USER23
77USER47
88USER39
99USER42
1010USER211
1111USER312
12
13[key (A column) of first highest value (C column) based on B13]USER1
14[key (A column) of second highest value (C column) based on B14]USER1
15[key (A column) of first highest value (C column) based on B15]USER2
16[key (A column) of second highest value (C column) based on B16]USER2
17[key (A column) of first highest value (C column) based on B17]USER3
18[key (A column) of first highest value (C column) based on B18]USER3

<tbody>
</tbody>

Basically I need to find only key, B13:B18 will be fixed value
 
Upvote 0
Try:
This is an array formula that must be entered with CTRL-SHIFT-ENTER. Drag formula down as needed.
Excel Workbook
ABC
11USER18
22USER18
33USER14
44USER25
55USER31
66USER23
77USER47
88USER39
99USER42
1010USER211
1111USER312
12
13USER11
14USER12
15USER210
16USER24
17USER311
18USER38
Sheet
 
Upvote 0

Forum statistics

Threads
1,214,791
Messages
6,121,611
Members
449,038
Latest member
apwr

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top