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

Recent content by cwilson

  1. C

    Using LOGEST (or trendline coefficient formulas) with blank cells

    Neither of those helped. Maybe this is a better way of asking: I took this formula, which is a bit different from my first post but accomplishes the same thing, {=LINEST(LN(A2:S2),A1:S1,TRUE,TRUE)} and added an if(isnumber(... to try to get it to ignore/skip blanks...
  2. C

    Hi All

    I've recently come across the same issue -- losing leading zeros when importing a .csv or a .txt file into excel. My solution: during the import process (ie. in the 'text import wizard' change the format of the column that contains that data to text or general.
  3. 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...
  4. 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...
See more
Back
Top