Search results

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.

OMG. Amazing. Thanks a lot guys.

Fred - Could you clarify what you mean by the helper column? To illustrate this is what I have: Large Cap-----Small Cap----Bonds-----Real Estate---Cash-------Total--------Scenario X%----------A%----------B%----------C%----------D%----------100%----------1...

Luke M - I appreciated the response. The portfolio weights have to add up to 1, because they cannot exceed 100% in total. I tried a modification of yours, but thing is, that the portfolios don't come out randomly weighted. What I mean is, I want to create a set of portfolios, say 1000 in...

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

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

Great article, thanks a lot for your help, got it to work!

Appreciate the response, however, Sheet2 doesn't have a column, rather it is just one function on the sheet, and I want to put all the elements of Sheet1!Column A through that function.

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