• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. C

    Use Min function within Sumproduct (or something smarter)

    Ah - works like a charm! Hot dog! I can't thank you enough. You have no idea. I am gushing. Chris
  2. C

    Use Min function within Sumproduct (or something smarter)

    I took Daffy333's suggestion and it getting me closer. It returns the MIN in the whole array, but not the MIN of each unique client. I've updated the spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0AizfNmXXHvYrdHVaaDJTd0FlZVRyYXRhU2duaVUwU3c&hl=en_US Luke, does this clarify the my...
  3. C

    Use Min function within Sumproduct (or something smarter)

    Good afternoon. I have a list of clients, with multiple users within each company. I have a column that tells me the number of days since any one user has purchased a product. I need to add 2 columns that will ultimately be used in a pivot table to: 1) Identify unique clients, not unique...
Back
Top