I have a spreadsheet that has Account Number, Trade Date (mm/dd/yyyy), and Trade Amount ($).
What I need is to group by Account Numbers, and Sum Trade Amounts for any trades falling within a 30 days of each other (any 30 days, not necessarily the same calendar month) and determine if it is more than a set amount ($10,000).
Any help would be greatly appreciated.
What I need is to group by Account Numbers, and Sum Trade Amounts for any trades falling within a 30 days of each other (any 30 days, not necessarily the same calendar month) and determine if it is more than a set amount ($10,000).
Any help would be greatly appreciated.
