- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Excel Formula Help
Posted on 3/26/18 at 12:26 pm to southernelite
Posted on 3/26/18 at 12:26 pm to southernelite
Formula does indeed work
Recently I have preferred to reduce the complexity of the formula if they get to large, especially if others have to look into it, or if I need to troubleshoot heavy models
In this case I did a concat of the dates and values in two rows above the XIRR calc (row 5 & 6)
=CONCAT(ADDRESS(MATCH(B$3,$A:$A,0),COLUMN($A:$A)),":",ADDRESS(MATCH(B$4,$A:$A,0),COLUMN($A:$A)))
result - $A$8:$A$247 (same thing for values just one column over)
Then your XIRR calc is just two indirects =XIRR(INDIRECT(B$6),INDIRECT(B$5))
Recently I have preferred to reduce the complexity of the formula if they get to large, especially if others have to look into it, or if I need to troubleshoot heavy models
In this case I did a concat of the dates and values in two rows above the XIRR calc (row 5 & 6)
=CONCAT(ADDRESS(MATCH(B$3,$A:$A,0),COLUMN($A:$A)),":",ADDRESS(MATCH(B$4,$A:$A,0),COLUMN($A:$A)))
result - $A$8:$A$247 (same thing for values just one column over)
Then your XIRR calc is just two indirects =XIRR(INDIRECT(B$6),INDIRECT(B$5))
Popular
Back to top
Follow TigerDroppings for LSU Football News