Hello all,
This is my first post, so I hope I am doing it right. I am trying to create a formula that will find customers with total amounts greater than $80,000 for a particular date from raw data, then to past that into a summary worksheet. I have attached my workbook to this post.
Specifically, I am trying to remove duplicates from the customer column in the ActualCollection worksheet, but I need to sum the amounts for the duplicates (ie B3:C4 would become "Pure Clean $3,200).
I would like to then do a vlookup on this new, non-duplicate list, and place the results in a summary tab. However, I only want to lookup customers with amounts greater than $80k each day, and I would also like to concatenate all customers (if there are more than one) that meet these criteria and place them in a single cell. Finally, I would like to format all of these results like the concatenated results in cell E2 of the ActualCollection worksheet.
I am not sure if it would be easier to use an advanced filter or some type of data consolidation rather than trying to create some kind of superformula, but any help is greatly appreciated!!!
Best,
Andrew
Bookmarks