filtering/matching with XIRR

D

Dean

Let's say I have the following portfolio, and I want to get the XIRR
filtered by the symbol, how would I do that? Something like:

=xirr(value*(symbol="IBM"), date*(symbol="IBM"))


value date symbol
 
Top