# Search:

Type: Posts; User: kylc3; Keyword(s):

## Search: Search took 0.00 seconds.

by kylc3
Replies
4
Views
5,653

### Re: XIRR returns 0.00% instead of a negative percentage

Thanks so much! One follow up question... I'm using this formula over rolling periods resulting in various outcomes, both positive and negative. Will this added parameter (-10%) be safe to use and...

by kylc3
Replies
4
Views
5,653

### XIRR returns 0.00% instead of a negative percentage

Hi,

I'm running a savings scenario where the ending value of my investment ends up being less than the total contributions based on monthly returns during a down market period, but the XIRR is...
3. ## Thread: XIRR with dynamic range

by kylc3
Replies
6
Views
3,531

### Re: XIRR with dynamic range

Thank you! I'll give it a shot.

This seemed to work as well... =xirr(m2:index(m2:m150,match("",i2:i150,)-1),i2:index(i2:i150,match("",i2:i50,)-1))
4. ## Thread: XIRR with dynamic range

by kylc3
Replies
6
Views
3,531

### Re: XIRR with dynamic range

Sorry, I tried to post a screen shot but it looks like it didn't work. Here's a link to a screenshot of the spreadsheet. Thanks!

https://imgur.com/a/HR6ko
5. ## Thread: XIRR with dynamic range

by kylc3
Replies
6
Views
3,531

### XIRR with dynamic range

Hi,

I work in the investment industry and am trying to calculate the XIRR of our various mutual funds using the dates and the monthly withdrawal amounts that change over time, with the ending...
6. ## Thread: MEDIAN formula returning #VALUE! - Help!

by kylc3
Replies
1
Views
153

### Re: MEDIAN formula returning #VALUE! - Help!

Anybody wanna take a stab at this one?
7. ## Thread: MEDIAN formula returning #VALUE! - Help!

by kylc3
Replies
1
Views
153

### MEDIAN formula returning #VALUE! - Help!

Hi!

I'm using the following array formula to find the MEDIAN of a string of values:
...
8. ## Thread: Min/Max/Average Arrays not working - HELP!

by kylc3
Replies
6
Views
146

### Re: Min/Max/Average Arrays not working - HELP!

dreid1011, you nailed it! Thanks so much!
9. ## Thread: Min/Max/Average Arrays not working - HELP!

by kylc3
Replies
6
Views
146

### Min/Max/Average Arrays not working - HELP!

I have several sets of data that I'd like to be able to use the same array formulas for but I'm having an issue if the data set is not complete, meaning the range in the array formula is longer than...
10. ## Thread: Find MIN within a range & count how many consecutive negative numbers until the MIN

by kylc3
Replies
15
Views
525

### Re: Find MIN within a range & count how many consecutive negative numbers until the MIN

Very cool! Thx Marcelo Branco !!!
11. ## Thread: Find MIN within a range & count how many consecutive negative numbers until the MIN

by kylc3
Replies
15
Views
525

### Re: Find MIN within a range & count how many consecutive negative numbers until the MIN

Thanks for the heads up! I switched to your formula. I have an additional request posted above. Any chance you could help me out?
12. ## Thread: Find MIN within a range & count how many consecutive negative numbers until the MIN

by kylc3
Replies
15
Views
525

### Re: Find MIN within a range & count how many consecutive negative numbers until the MIN

Is it possible to get an additional formula that will count the total number of negative periods that the MIN is a part of? So, in my example, the total would be 10. I'm working with a very lengthy...
13. ## Thread: Find MIN within a range & count how many consecutive negative numbers until the MIN

by kylc3
Replies
15
Views
525

### Re: Find MIN within a range & count how many consecutive negative numbers until the MIN

Wow, that was fast! Thank you all for the feedback! I applied DRSteele's formula and it worked great! I need to build out some more functionality in the file, but first I'll have to figure out what...
14. ## Thread: Find MIN within a range & count how many consecutive negative numbers until the MIN

by kylc3
Replies
15
Views
525

### Find MIN within a range & count how many consecutive negative numbers until the MIN

Let's say I have a column with the following values:

...
-0.26%
-0.09%
0.00%
0.00%
-0.25%
-0.82%
-1.08%
Results 1 to 14 of 14