• 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. J

    Need a dynamic sumproduct for visible cells in a vertical array HELP!!!!

    Ok lets try this. At this point I am in dire need I have a reporting deliverable on may 8 and need all of this data summarized. I really appreciate your help!
  2. J

    Need a dynamic sumproduct for visible cells in a vertical array HELP!!!!

    This is a big one. I have some customer data inputs at the warehouse level that I need to summarize into larger groups of warehouses that we have called "SELL TO's". The data file has over 10K rows and has filters applied to it. There are 8 different product groups, 192 customer "SHIP TO's"...
  3. J

    Using Symbols with cell refrences to indicate increases or decreases

    Luke, Thank you that helped so much. I was looking for a particular symbol, you helped me find it.
  4. J

    Using Symbols with cell refrences to indicate increases or decreases

    I noticed in the dashboard contest that some people had used symbols and conditional formatting to show a green upward facing triangle with a percentage increase. There was a recent post about this technique but I cannot find it. Could someone please point me in the correct direction?
  5. J

    Use Offset() to dictate what cell a Vlookup or (index/ match) returns

    Thank you all very much. I didn't expect a response so quickly. I will try this formula later today. It sounds like it will work perfectly.
  6. J

    Use Offset() to dictate what cell a Vlookup or (index/ match) returns

    Hello. I am new to this site and really love it, good work Chandoo! I ran into a very frustrating situation where I needed to simply offset the result of a vlookup down one row. I was under a deadline and had to re-work the entire sheet another way to get what I wanted. =vlookup(a3,'so and so...
Back
Top