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

    Does VBA macros have a max number of cells?

    Maybe I was thinking too hard...this works well and doesn't require vba :P = if(A3="",B2,A3) Put that into an empty column. Problem solved!!
  2. G

    Does VBA macros have a max number of cells?

    I just used the Macro recorder and created this "Fill_Blanks" code. I have a column w many blanks. I want to fill in all the blanks by referring to the last non-blank cell above. (I tried the GoTo Special Blanks =cellref CTRL+ENTER trick, but the range was too big) I was wondering if I am...
  3. G

    Anyone ever use Tableau?

    **sorry guys I'll have to get back to you one at a time. drowning in work/data** @SirJB7 lol! Yes, I have more than 1048576 rows, but only 13 columns. It's daily trading data, which intrigues me, but could be boring to others. And it's as "real life" as it gets! To me, there's nothing as...
  4. G

    Anyone ever use Tableau?

    @bobhc, @SirJB7 et al. Hi guys, not quite on the topic of Tableau, but relevant to my situation nevertheless. A case of Carlsberg on me if you can help me w learning A database ANY database to suit my needs which are rather simple. I ran out of cells in Excel. That's all. So onwards and...
  5. G

    Anyone ever use Tableau?

    I downloaded the trial too, but haven't had a chance to play with it. If life wasn't a finite resource I would LOURVE to learn everything. Unfortunately (or fortunately as the case may be ;P) I would like to sleep again...one day... So Tableau allows for "ease of access" to the data source...
  6. G

    How do I automate the YTD avg of previous yrs based on the # days in current yr

    Sorry for the delay, but yes the formulae are ok. I would like to calculate current YTD average for each category (ie interest rates, equities, fx, energy, commodities, metals) in the current year, and be able to compare the current YTD average with the YTD average of the previous 4 years. I...
  7. G

    Anyone ever use Tableau?

    Soooooo pretty! Just wondering if all this could also be done in excel? I have my hands full trying to wrap my head around vba and Access o_O I don't know if I have the intestinal fortitude to try yet ANOTHER software product... But the pictures sure are pretty!
  8. G

    Send email when a Cell value is less than a number

    great worksheet bobhc. thx!
  9. G

    How do I automate the YTD avg of previous yrs based on the # days in current yr

    How do I automate the YTD average of the previous years (i.e. 2008, 2009, 2010, 2011) to update as soon as I populate the data for the current year (i.e. 2012)? For example, as of June 22, 2012 we have 121 total trading days. How do I automate the average of 121 days in 2008, 2009, 2010 and...
Back
Top