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

    How to fill 86,400 rows of time from 0:00:00 to 23:59:59

    Worked like a charm, thanks fred! I put redundant info on it, this is all needed. --------A 1 0:00:00
  2. S

    How to fill 86,400 rows of time from 0:00:00 to 23:59:59

    Hello folks, I would like to fill the time 0:00:00 to 23:59:59 (A1:A84400) without dragging the mouse forever. This is how I try to do it but unsuccessful. ........A 1 0:00:00 2 0:00:01 3 I highlighted A1:A3, clicked 'HOME'> 'FILL' > 'Series'> 'check radio Series in...
  3. S

    Beyond row 1048576, Can Powerpivot save me?

    Thanks everyone! I experimented PowerPivot again and took 5 minutes to import 7 million datapoints and additional 5 minutes to load the .txt file from hard disk. Hui was right on over 5 million data is not an issue. Well 'plot' means creating a graph on the pc not in a printout form, though...
  4. S

    Beyond row 1048576, Can Powerpivot save me?

    Hi all, I'm using 32bit Excel 2010 in 2Gb Intel DuoCore Vista. Question: I need to plot a linegraph of 5 million of datapoints with 2 variables, time(x-axis) and quantity(y-axis). I can import 1048576 rows of .txt in worksheet1, but failed to continue importing in worksheet2 the...
Back
Top