IRR function
 

Hi,

I had a question about the IRR function, I looked in excel's help but could
not find an answer.

I have two streams of numbers in different areas of the worksheet, and I
want to do an IRR on the two discountinuous streams. Stream 1 comes first in
order followed by stream 2.

Is there any way to do this. Otherwise I was just going to paste the two
streams together in a seperate tab, but that seems a little messy.

Thanks for your help