non-volatile

Hello All: I am trying to find a way to calculate the XIRR for many investments over a vast Data Input structure that already exists and which is constantly being updated with new Inputs for the respective investments. The challenge is to find a standard formula that produces XIRR...

Hello,</SPAN></SPAN> For now using in the cell C5 following formula, is there any replacement of this non-volatile formula to regular formula </SPAN></SPAN> Book1ABC1231245126172839510611101212134014601565167217381861Sheet2Cell...

I am using this =INDEX($C$2:$C$12,MATCH($A2&$B2,INDEX($A$2:$A$12&$B$2:$B$12,0),0)) formula to find lookup value where lookup criteria are A2 and B2. There are many lookup values against lookup criteria A2 and B2, simply i want to find them using non-volatile formula.

Say I am interested in the first 100 rows of column_j and I know the j. How can I retrieve this values in non-volatile way, using formulas?

Hi! I am sure that there are better ways to solve my issue, but I am not proficient enough to come up with a solution myself, so i am throwing myself at your mercy :P What I am trying to do is to get identically structured information from the same cells in multiple worksheets (up to 200) and...

Hi All, I'm currently working on a very large file and excel is consistently crashing on me. I believe this is largely due to the number of indirect functions I'm using. I have 31 sheets, named D1 - D31, for each day of the month. I then have a data sheet and 6 sheets analysing the monthly...