I have a list of people which have corresponding dollar amounts and I'd like to search that list, validate the last name, first name and email addresses and if they match, summarize the corresponding $ amounts into a second 'summary' tab. So if there are 2 or more rows of data for an individual person, the summary would add all the dollar amounts for the person into one summary line item on the summary tab.Validate and Summarize.xlsx
I've attached a sample copy of the data to this post and was wondering if anyone would know how to
Bookmarks