Extracting multiple rows at a time

[maretec]

I have a table where loan payments are recorded.

Each borrower can make one, 2, 3 or more payments during the month to complete their monthly loan payment.

For example, if the monthly loan payment is $956.25, the borrower can make 4 payments during the month. I'm going to pick random amounts, say $256.25, $200.00, $350.00, and $150.00. These 4 payments complete the monthly loan payment of $956.25.

The [Monthly Payment] column of the table sums the payments made by a borrower during a month. In the example above, the [Monthly Payment] column will have the following values: $256.25, $456.25, $806.25, and $956.25

I want to extract the rows whose [Monthly Payment] has the highest amount for each loan and paste them into another table.

In the image below, I have 3 loans: d88bc4a9, c672d16b and 0c567ba0.

I want to extract rows 18, 19 and 21.

I've been able to extract one row at a time. I've tried "Actions" to execute a loop to extract all rows from a month, but I don't find the right way to do it.

Any advice will be welcome.