Select Number (Row) w/ Largest Amount

[NBPSE]

The total in the Amount column for the corresponding Number column that includes 40 and 50 changes from month to month. How can I use a formula that selects the row with the largest Amount each month? For Example, this month 50 has the largest amount, so I would like the selection to only include Number 50, and Amount 452526.59.

[Hub119 · Accepted solution]

Would recommend using a combination of a sort tool and a sample tool... sort descending on Amount to have your greatest amount record listed first and then use a sample tool configured to select the first record only.

[NBPSE]

Worked perfectly, thank you!