+ Reply to Thread
Results 1 to 1 of 1

Superformula to remove duplicates, Sum, vlookup and concatenate

  1. #1
    Registered User
    Join Date
    01-20-2013
    Location
    San Francisco, California, USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Superformula to remove duplicates, Sum, vlookup and concatenate

    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
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1