Spreadsheet: 731984d1620734354-excel-how-to-filter-and-returning-selected-amount-of-results-how-to-filter
Sheet: Sheet1

RAW DATA |  |  |  |  |  | Amount to Assign |  |  |  |  |  | RESULT
Name | ID | Data | Data2 | Data3 |  | Name | N to assign |  |  |  |  | Name | ID | Data | Data2 | Data3
Ian | 69854198 | Data | Data | Data |  | Ian | 5 |  |  |  |  | Ian | 69854198 | Data | Data | Data
Jessica | 84968 | Data | Data | Data |  | Jessica | 5 |  |  |  |  | Ian | 651 | Data | Data | Data
Duarte | 4941619 | Data | Data | Data |  | Duarte | 5 |  |  |  |  | Ian | 48 | Data | Data | Data
Micheal | 64451 | Data | Data | Data |  | Micheal | 5 |  |  |  |  | Ian | 8 | Data | Data | Data
[NAME] | 4984198 | Data | Data | Data |  | [NAME] | 5 |  |  |  |  | Ian | 848466565 | Data | Data | Data
Ian | 651 | Data | Data | Data |  |  |  |  |  |  |  | Jessica | 84968 | Data | Data | Data
Jessica | 869 | Data | Data | Data |  |  |  |  |  |  |  | Jessica | 869 | Data | Data | Data
Duarte | 949494984 | Data | Data | Data |  |  |  |  |  |  |  | Jessica | 8 | Data | Data | Data
Micheal | 544455 | Data | Data | Data |  |  |  |  |  |  |  | Jessica | 888484 | Data | Data | Data
[NAME] | 3 | Data | Data | Data |  |  |  |  |  |  |  | Jessica | 984 | Data | Data | Data
Ian | 48 | Data | Data | Data |  |  |  |  |  |  |  | Duarte | 4941619 | Data | Data | Data
Jessica | 8 | Data | Data | Data |  |  |  |  |  |  |  | Duarte | 949494984 | Data | Data | Data
Duarte | 84 | Data | Data | Data |  |  |  |  |  |  |  | Duarte | 84 | Data | Data | Data
Micheal | 31 | Data | Data | Data |  |  |  |  |  |  |  | Duarte | 68 | Data | Data | Data
[NAME] | 1111 | Data | Data | Data |  |  |  |  |  |  |  | Duarte | 84 | Data | Data | Data
Ian | 8 | Data | Data | Data |  |  |  |  |  |  |  | Micheal | 64451 | Data | Data | Data
Jessica | 888484 | Data | Data | Data |  |  |  |  |  |  |  | Micheal | 544455 | Data | Data | Data
Duarte | 68 | Data | Data | Data |  |  |  |  |  |  |  | Micheal | 31 | Data | Data | Data
Micheal | 984 | Data | Data | Data |  |  |  |  |  |  |  | Micheal | 984 | Data | Data | Data
[NAME] | 4 | Data | Data | Data |  |  |  |  |  |  |  | Micheal | 84894 | Data | Data | Data
Ian | 848466565 | Data | Data | Data |  |  |  |  |  |  |  | [NAME] | 4984198 | Data | Data | Data
Jessica | 984 | Data | Data | Data |  |  |  |  |  |  |  | [NAME] | 3 | Data | Data | Data
Duarte | 84 | Data | Data | Data |  |  |  |  |  |  |  | [NAME] | 1111 | Data | Data | Data
Micheal | 84894 | Data | Data | Data |  |  |  |  |  |  |  | [NAME] | 4 | Data | Data | Data
[NAME] | 323123 | Data | Data | Data |  |  |  |  |  |  |  | [NAME] | 323123 | Data | Data | Data
Ian | 8177148 | Data | Data | Data
Jessica | 474 | Data | Data | Data
Duarte | 8 | Data | Data | Data
Micheal | 99999999 | Data | Data | Data
[NAME] | 9999 | Data | Data | Data
Ian | 999 | Data | Data | Data
Jessica | 99 | Data | Data | Data
Duarte | 99999998484 | Data | Data | Data
Micheal | 46848 | Data | Data | Data
[NAME] | 64 | Data | Data | Data
 | 8484 | Data | Data | Data
Ian | 486 | Data | Data | Data
Jessica | 21515 | Data | Data | Data
Duarte | 48 | Data | Data | Data
Micheal | 18484 | Data | Data | Data
[NAME] | 848484 | Data | Data | Data
Ian | 48 | Data | Data | Data
Jessica | 4684 | Data | Data | Data
Duarte | 83335669 | Data | Data | Data
Micheal | 5 | Data | Data | Data
[NAME] | 87 | Data | Data | Data
Ian | 8 | Data | Data | Data
Jessica | 66 | Data | Data | Data
Duarte | 666 | Data | Data | Data
Micheal | 8615 | Data | Data | Data
[NAME] | 69419494 | Data | Data | Data