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

    Alternatives to WEEKNUM

    Hey all, In one of the dashboards I've built, I use simple conditional formatting to show upcoming invoice due dates in different colours, grouped by which week the fall due in. For example: WEEKNUM(DueDate) < WEEKNUM(TODAY()) : Red WEEKNUM(DueDate) = WEEKNUM(TODAY()) : Orange...
  2. D

    Finding change in value over specified time.

    Hey guys, I have a friend who has been tracking their weight loss in a spreadsheet, and asked me to do some visualisations on it. One thing I'd like to be able to do is report the total weight lost for a given period. Is there an easy way to do this via formula? For example, I have two...
  3. D

    Consolodating two tables.

    Hey guys, Here's a little background, and what I am trying to do. We import products that require testing at pre-determined quantity intervals, i.e. We need to test one in every 1000 items. We raise a shipment for each import and a purchase order for each test. I am pulling in the shipment...
Back
Top