• 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 Henrique Carvalho

  1. H

    Compound Interest Function in VBA - Define only a range of Monthly Data

    That's amazing Hui! Thanks again my friend!
  2. H

    Compound Interest Function in VBA - Define only a range of Monthly Data

    Hi kchiba! Thanks for your sugestion, but the range that I work is dynamic. Besides that I really want to understand why the formula doesn't work. Some thoughts: 1. For every function that I use in VBA I have to use Application.WorksheetFunction? So, using 2 functions it would be like...
  3. H

    Compound Interest Function in VBA - Define only a range of Monthly Data

    Hi Guys! I have some data like this: Month | Asset Jan/10 0.50% feb/10 1.50% ... ... In Excel, you could just calculate the compund interest using: =SUMPRODUCT(PRODUCT(b2:b1000+1)-1) Where the data range is in b2 Down This formula is equivalent of...
  4. H

    Link a Data Table Name with a Range

    Many thanks Hui! This will save me a lot of time!
  5. H

    Link a Data Table Name with a Range

    Hi guys! I have a doubt regarding Excel Data Tables. I was wondering if it's possible to refer to it using a range. For example: The formula is: =COUNTIF(abcp11[Data];">=01/09/10") I want to make the "abcp11" part variable, using the name "abcp11" in the range B5...
  6. H

    Data Tables - How to fix a column?

    Hi Chandoo! Your formula worked perfectly! I apreciate your help. Thanks! Sucess my friend!
  7. H

    Data Tables - How to fix a column?

    Hi Hui! I´ve already tried Ctrl C & Ctrl V but it dosen´t work. See the spreadsheet below to understand why: http://www.megaupload.com/?d=15GKYWK0 Thanks!
  8. H

    Data Tables - How to fix a column?

    Hi Guys! Is there something like F4 for data tables? I can´t fix (lock) a certain column (witch contains the months of the data) using data tables. So, when i try to drag the formula to other cells, the reference that i wanted to be fixed moves. Any help? Thanks in advance!
  9. H

    Correlation - Return the assets that have the bigger correlation

    Wow! You´re tha Man Hui! That´s a freaking nice Beasty! Worked very well. Thanks!
  10. H

    Correlation - Return the assets that have the bigger correlation

    Hi Guys! I´ve already done all the procedures: 1. Calculate the correlation between assets 2. Find the top 5 larger values and the top 5 smaller values. Instead, i´ve had no sucess returning what are the assets that match this top 5 correlations. I´m sure that this is a problem of...
  11. H

    Data Problem with Tables - Correlation and Standart Deviation

    Wow! Thanks Hui! Worked Perfectly!
See more
Back
Top