LARGE function / Bringing top 5s from Data

[nomanfiroz]

Hi everybody,
Good morning.

1. I use large function to bring the top 5 number from a list to pay rebate to our customers.


2. I also use large function: if two customers bought the same quantity of goods, LARGE function bring the first name and number available. Please see the example below. In column A, I have the number of goods purchased from us and in column B I have names of the customer.

I need to bring the quantity and names of the customer who purchased 10 or more. How I can bring the quantity and names in another list tha buys 10 or more?


For example,
Col A (Qty) Col B (Name)
10 A
8 B
15 C
15 D
12 E
13 F
12 G
2 H
1 I

Many thanks in advance
Firoz


https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.eileenslounge.com/viewtopic.php?p=312533#p312533
https://www.eileenslounge.com/viewtopic.php?f=44&t=40373&p=312499#p312499
https://www.eileenslounge.com/viewtopic.php?p=311844#p311844
https://archive.org/download/wlsetup-all_201802/wlsetup-all.exe
https://www.eileenslounge.com/viewtopic.php?p=311826#p311826
https://www.eileenslounge.com/viewtopic.php?f=37&t=40261&p=311783#p311783
https://www.eileenslounge.com/viewtopic.php?p=310916#p310916
https://www.eileenslounge.com/viewtopic.php?p=310720#p310720
https://www.eileenslounge.com/viewtopic.php?f=56&t=40034&p=310171#p310171
https://www.eileenslounge.com/viewtopic.php?p=310110#p310110
https://www.eileenslounge.com/viewtopic.php?p=310024#p310024
https://www.eileenslounge.com/viewtopic.php?p=309121#p309121
https://www.eileenslounge.com/viewtopic.php?p=309101#p309101
https://www.eileenslounge.com/viewtopic.php?p=308945#p308945
https://www.eileenslounge.com/viewtopic.php?f=30&t=39858&p=308880#p308880
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

[Admin]

Hi

Assume your data in A2:B10,

In C2 and copied down,

=IF(A2>=10,RANK(A2,$A$2:$A$10)+(COUNTIF($A$2:A2,A2)-1),"")

Array formula. Entered with CTRL+SHIFT+ENTER

In D2 and copied down and across,

=INDEX(A$2:A$10,MATCH(ROWS(D$2:D2),$C$2:$C$11,0))

Replace the criteria in red color.