I have exported a list of 4627 donations from QuickBooks to Excel. The list has columns for Name, Address, City, State, Zip, Phone, and Amount (of an individual donation). I would like to filter this list to include only donors with 2 or more donations, the sum of which is $500 or more, with the total of that sum displayed. For instance, if John Doe has donations of $100, $300, and $200, he would be listed only once with the total amount of his donations displayed as $600. If Jane Doe has 9 separate donations of $50 (totaling $450), she is eliminated from the list. Would this be a pivot table, a filter, or a formula?
Bookmarks