Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I show multiple worksheets on multiple screens? | Excel Discussion (Misc queries) | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
Return Multiple Results with Lookup | Excel Worksheet Functions | |||
XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) | |||
How do I avoid saving multiple Excel/Wordfiles for versioning purp | Excel Discussion (Misc queries) |