ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Multiple Vectors Notation (https://www.excelbanter.com/excel-discussion-misc-queries/24611-multiple-vectors-notation.html)

Bill Martin -- (Remove NOSPAM from address)

Multiple Vectors Notation
 
I keep running into situations where functions demand vector input and I
end up handling them in a clumsy manner where it seems a more elegant
one must exist.

For example the function [ ]=XIRR(Yvector,Xvector,Guess). In the
situation where I have multiple columns of X,Y data I keep manually
combining them into a single column for the convenience of the XIRR
function. Is there some notation where I can indicate multiple columns
of X,Y data to the XIRR function directly? Without copying masses of
data around and refomatting things?

Thanks...

Bill


All times are GMT +1. The time now is 04:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com