Search results

Hi bosco_yip, I thank you for your effort, but your solution does not provide the correct answer. For instance, in 2008 the interest rate was fixed at 3.0%. When I set up a table with the data organized the way XIRR expects the data to be organized, and I use the exact dates of the deposits...

I don't think I made myself understood in my original post. Maybe the attached spreadsheet will help. I update this monthly and would like to pick a start date and an end date and determine the annualized rate of return between those dates. I understand how the XIRR function works when the...

I've got a spreadsheet with 25 years of data from my investments. I'd like to know what my annualised rates of return are. For each investment, the first column (A) is the dates; the second column (B) is the value of that investment on that date; and the third column (C) is the value of any...

For future reference, I fixed my PERCENTILE problem with a little help from Google. Solution to be found at http://www.mrexcel.com/forum/excel-questions/407917-quartile-percentile-function-range-containing-n.html Now things are working as hoped!

Ugh, fix one thing, break another. On a different worksheet I use the data in those columns to calculate percentiles. Now that I'm using NA() instead of "" for when there's an error, the =PERCENTILE.EXC() function is broken and returns a value of #N/A whereas it worked just fine when I used ""...

Thanks for that Hui. I was not aware of the NA() function. Quite interesting behaviour I observe depending on what the cells are filled with: "": ISBLANK() returns FALSE; Sparklines treats the "" cells as though they are value zero regardless of Hidden & Empty Cells setting NA(): ISBLANK()...

I'm attempting to make a Sparkline but I'm not getting gaps in the Sparkline as I would expect. Column A contains Sales for the Week. Column B contains Hours Worked for the Week. Column C contains Sales per Hour: =IFERROR(Column A/Column B,"") The IFERROR is necessary becomes sometimes...

Thanks a bunch NARAYANK991 I simply added a column adjacent to Week Ending called Reverse Date, used your formula: =INDEX(DateRange,ROWS(DateRange)-ROW()+MIN(ROW(DateRange))) to fill it with the dates in reverse order. Then I set up a new named range ReverseDate=Revenue[Reverse Date] and...

Sorry if this has been asked and answered before but I haven't had luck finding an answer with the search function. I have a Table named Revenue. The first column is Week Ending. The first entry (A3) is 08-Jan-11. The next cell down (A4) is =A3+7 and so on to the bottom of the column. Every...