• 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. 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...
  2. 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...
  3. 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!
  4. 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...
  5. H

    Data Problem with Tables - Correlation and Standart Deviation

    Hi Guys! I have a table with the mensal variation of some assets. The period is 1999-2010. I´d already calculated the annual compound growth for each year with sucess, using sumproduct formula to identify what the year is and then return only the data that i want. Although, I´m having some...
  6. H

    Pivot Tables - Compound Interest/Growth

    Hi guys! I´ve been trying to figure out a way for calculate compound interest in pivot tables, but haven´t found anything that works. In this link below i´ve written some observations inside the spreadsheet (v.2007). http://www.megaupload.com/?d=PYOBGPH0 Thanks in advance.
  7. H

    Make your Chart Legends Legendary - How to bold part of the text inside boxes?

    Excellent post Point. I was wondering if we could bold some part of the text inside the boxes to highlight important information (like the percentage of the variation y-o-y). Does anyone know how to do it? (bold only part of the text inside boxes) Thanks in advance!
  8. H

    Excel v.2003 - An alternative formula for EOMONTH (v.2007)

    Hi guys! I use the 2003 version of MS Excel. Altough, i need the use of formula (EOMONTH) in v.2007. Is there any way i can make a alternative formula in v.2003 to simulate the formula (EOMONTH) in v.2007? Thanks for your Help!
Back
Top