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

    slooooow calculation with COUNTIF

    Thank you HUI You're so right! The data is static so no need to hold on to anything but the values and as you say I will keep the formula in the first or last of the rows - for next time I need to recalculate a new batch. Brilliant, brilliant. /loor
  2. L

    slooooow calculation with COUNTIF

    Need some advise from someone who has the black belt in excel. Im preparing the main data for subsequent pivottabeling, but my data suffers from slow calculation due to the use of a series of COUNTIFS. The COUNTIF is looking in a cell where week numbers have been set up in a string...
Back
Top