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

    VLOOKUP

    Hello, what is the difference between VLOOKUP and +VLOOKUP? I'm basically forming a data table, and it seems that Chandoo has used +VLOOKUP for the DT, just curious to know what the difference is.
  2. P

    Portfolio Weights

    Hello. I am building a excel sheet which will find the return and risk of a large number of portfolios in order to create an efficient frontier. The problem I have is: - I want to create a large set of portfolios with random weights. Say, x go to large cap, y go to small cap, z go to bonds...
  3. P

    Conditional Formatting

    Hello. Have a bit of a problem in Excel 2003 and would appreciate some help. I have one column of numbers in Column B and another Column of numbers in Column C, in Column D I have D=ABS(B-C) for the whole column. What I am trying to do is I want cells in column D to turn red whenever the value...
  4. P

    Doing a Function on each Element of a Column and pasting it next to Element

    Hello, I am new to the forums, and starting to learn VBA. Great Site. I have a question, some help would be much appreciated. What I am doing is, on Sheet 1, I have a column [A1:A10} containing values [1-10]. On Sheet 2, I take each element of the Sheet 1 column, and multiply by 2(or do...
Back
Top