• 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

    Using LOGEST (or trendline coefficient formulas) with blank cells

    I have about 25,000 rows of data (oil production data over time) -- some are complete ranges, but most have a few blanks. I need the decline rate of each row (ie. a coefficient in the exponential trendline), and so it seems to avoid making 25,000 charts and fitting exp trendlines, I can use...
  2. C

    Importing text into PowerPivot using a schema.ini file

    I've decided that PowerPivot could be the answer to my data dreams ... if I can get past this issue! I'm combined 13 separate .csv files into one combined .csv file (3 million rows, hence my new found excitement for PowerPivot). The columns contain various data types, including mixed letter and...
Back
Top