How to find large fuel consumption in Excel

[primasatria]

Dear all,

I have data of monthly fuel consumption, let's say January 2024.
Using large function, I can get the list of top ten based on quantity of fuel consumption.

In "summary" sheet, column F (quantity in liter) based on "Dataset" sheet:
1. 500
2. 500
3. 500
4. 450
5. 400

In "Dataset" sheet:
column A = ID Badge
row 1: 22001
row 2: 22002
row 3: 22004
row 4: 22003

column B = First Name
row 1: Jim
row 2: Andrew
row 3: Mike
row 4: Greg

Column C = Fuel Quantity
row 1: 500
row 2: 500
row 3: 400
row 4: 500

How do I know or lookup value in "Summary" sheet from "Dataset" sheet that the duplicate value is belong to a certain driver.
for the first 500 should be Jim, ID Badge 22001
for the second 500 should be Andrew, ID Badge 22002
for the third 500 should be Greg, ID Badge 22003

If can not solve using Excel functions, is there any chance to do it in Excel VBA? And how is the code?

Thank you very much for kind assistance and helpin hand.
Best regards,
prima - Indonesia

 

[SunnyAlv]

Try this

=SORTBY(A2:C5,A2:A5,1,B2:B5,1,C2:C5,1)

 

[primasatria]

Try this

=SORTBY(A2:C5,A2:A5,1,B2:B5,1,C2:C5,1)

View attachment 105353

Dear SunnyAlv,

Thanks for your kind assistance and help.
Problem solved !!!

Thank you,
prima - Indonesia

 

[SunnyAlv]

Dear SunnyAlv,

Thanks for your kind assistance and help.
Problem solved !!!

Thank you,
prima - Indonesia

Aman bro, no problem