Spreadsheet: 840684d1692900566-array-formula-to-top-nth-customer-and-amount-base-on-criteria-ask
Sheet: Sheet1

Company Name | Status | Amount |  |  |  |  |  |  |  |  | Company Name | Amount
123 Trading | 31-60 days | 8725 |  | Current |  |  | 31-60 days | Top | 10 |  | 123 Trading |  |  |  | Column A:C is my data. What I want, is a formula that will generate a list of the Top X (base on J2 value) and also [NAME]. [NAME] h4:I13. I do not want to use helper column. Is there a way to use formula to auto generate H4:I13?
123 Trading | Current | 3885 |  | 1-30 days |  | Ranking | Company Name | Amount |  |  | ABC Pte Ltd
123 Trading | Current | 2349 |  | 31-60 days |  |  |  |  |  |  | Apple Pte Ltd
123 Trading | > 90 days | 6871 |  | 61-90 days |  | 2 |  |  |  |  | Boon Kok Ltd
123 Trading | 31-60 days | 2657 |  | > 90 days |  | 3 |  |  |  |  | [NAME]
ABC Pte Ltd | Current | 8211 |  |  |  | 4 |  |  |  |  | Coconut Ltd
ABC Pte Ltd | 1-30 days | 7696 |  |  |  | 5 |  |  |  |  | Go Live Pte Ltd
ABC Pte Ltd | 1-30 days | 6021 |  |  |  | 6 |  |  |  |  | [NAME]
ABC Pte Ltd | > 90 days | 3408 |  |  |  | 7 |  |  |  |  | Kelay Ltd
ABC Pte Ltd | Current | 3565 |  |  |  | 8 |  |  |  |  | M & P Ltd
Apple Pte Ltd | 1-30 days | 6905 |  |  |  | 9 |  |  |  |  | Mdada Pte Ltd
Apple Pte Ltd | 31-60 days | 4753 |  |  |  | 10 |  |  |  |  | Moneymax Trading
Apple Pte Ltd | Current | 7187 |  |  |  |  |  |  |  |  | Pot Black Ltd
Boon Kok Ltd | 31-60 days | 9053 |  |  |  |  |  |  |  |  | [NAME]
Boon Kok Ltd | 61-90 days | 1850 |  |  |  |  |  | 18661 |  |  | SBO Trading
Boon Kok Ltd | 1-30 days | 1659 |  |  |  |  | [NAME] | 16588 |  |  | SGTV Pte Ltd
Boon Kok Ltd | 61-90 days | 6144 |  |  |  |  | [NAME] | 14967 |  |  | Sing Enterprise
Boon Kok Ltd | 31-60 days | 9608 |  |  |  |  | 123 Trading | 11382 |  |  | Spinny Ltd
[NAME] | > 90 days | 4852 |  |  |  |  | Pot Black Ltd | 10597 |  |  | Thinkwise Pte Ltd
[NAME] | 31-60 days | 9926 |  |  |  |  | Spinny Ltd | 9189 |  |  | [NAME]
[NAME] | 31-60 days | 6662 |  |  |  |  | [NAME] | 8385 |  |  | XYY Trading
Coconut Ltd | 1-30 days | 5334 |  |  |  |  | [NAME] | 7181
Coconut Ltd | 61-90 days | 5909 |  |  |  |  | Go Live Pte Ltd | 6456
Coconut Ltd | 1-30 days | 9184 |  |  |  |  | Sing Enterprise | 4760
Coconut Ltd | 1-30 days | 2762
Coconut Ltd | 61-90 days | 3453
Go Live Pte Ltd | 1-30 days | 3452
Go Live Pte Ltd | 31-60 days | 6456
Go Live Pte Ltd | 1-30 days | 2612
Go Live Pte Ltd | 1-30 days | 5294
[NAME] | > 90 days | 7823
[NAME] | 31-60 days | 7181
[NAME] | 61-90 days | 9762
[NAME] | Current | 9076
Kelay Ltd | 1-30 days | 5312
M & P Ltd | Current | 1392
M & P Ltd | 61-90 days | 1042
M & P Ltd | 31-60 days | 4590
M & P Ltd | Current | 2262
M & P Ltd | 61-90 days | 2067
Mdada Pte Ltd | 31-60 days | 2347
Mdada Pte Ltd | 61-90 days | 4016
Moneymax Trading | 1-30 days | 8016
Moneymax Trading | Current | 5903
Pot Black Ltd | 31-60 days | 3715
Pot Black Ltd | Current | 1021
Pot Black Ltd | 1-30 days | 9793
Pot Black Ltd | 31-60 days | 6882
Pot Black Ltd | 1-30 days | 7184
[NAME] | 1-30 days | 5715
[NAME] | 31-60 days | 8385
[NAME] | 1-30 days | 6213
[NAME] | > 90 days | 5481
[NAME] | > 90 days | 7988
[NAME] | 1-30 days | 5345
[NAME] | Current | 1437
SBO Trading | > 90 days | 7162
SBO Trading | Current | 9221
SBO Trading | > 90 days | 5117
SBO Trading | 61-90 days | 5327
SGTV Pte Ltd | Current | 5809
SGTV Pte Ltd | > 90 days | 6903
SGTV Pte Ltd | 61-90 days | 4871
Sing Enterprise | 61-90 days | 8715
Sing Enterprise | 31-60 days | 4760
Sing Enterprise | Current | 4684
Sing Enterprise | 1-30 days | 2129
Sing Enterprise | Current | 5890
Spinny Ltd | Current | 7588
Spinny Ltd | 1-30 days | 9365
Spinny Ltd | 1-30 days | 3371
Spinny Ltd | 31-60 days | 9189
Spinny Ltd | Current | 9152
Spinny Ltd | 61-90 days | 7425
Thinkwise Pte Ltd | > 90 days | 3240
Thinkwise Pte Ltd | 1-30 days | 9745
Thinkwise Pte Ltd | Current | 7196
Thinkwise Pte Ltd | 61-90 days | 2010
Thinkwise Pte Ltd | 61-90 days | 1513
Thinkwise Pte Ltd | 1-30 days | 8528
Thinkwise Pte Ltd | Current | 1508
[NAME] | 31-60 days | 6261
[NAME] | 1-30 days | 4078
[NAME] | 31-60 days | 8706
[NAME] | 61-90 days | 1946
[NAME] | 61-90 days | 3733
XYY Trading | 61-90 days | 6892
XYY Trading | 1-30 days | 2699
XYY Trading | 1-30 days | 7957
XYY Trading | 1-30 days | 8936
XYY Trading | Current | 9103