btadams
Well-known Member
- Joined
- Jan 6, 2003
- Messages
- 1,943
Hello Everybody!
I'm trying to calculate a percentile on a dynamic named range that references two non-contiguous ranges and not having success. First I tried using a static named range and it worked. Then I made the named range dynamic, NMFL_Load, using =OFFSET((Pivots!$FR$6:$GS$31,Pivots!$FR$44:$GS$56),0,Pivots!$FR$1) where Pivots!$FR$1 changes based on user input. I then entered the formula =PERCENTILE.INC( NMFL_Load,0.95) and I get a #Value error.
I also tried making the named range static, Pivots!$FR$6:$GS$31,Pivots!$FR$44:$GS$56, and then using the formula =PERCENTILE.INC( OFFSET( NMFL_Load,0,Pivots!$FR$1),0.95) and get the same error. However, if I just use the static named range, =PERCENTILE.INC( NMFL_Load, 0.95) it works
Anyone tried this before?
I'm trying to calculate a percentile on a dynamic named range that references two non-contiguous ranges and not having success. First I tried using a static named range and it worked. Then I made the named range dynamic, NMFL_Load, using =OFFSET((Pivots!$FR$6:$GS$31,Pivots!$FR$44:$GS$56),0,Pivots!$FR$1) where Pivots!$FR$1 changes based on user input. I then entered the formula =PERCENTILE.INC( NMFL_Load,0.95) and I get a #Value error.
I also tried making the named range static, Pivots!$FR$6:$GS$31,Pivots!$FR$44:$GS$56, and then using the formula =PERCENTILE.INC( OFFSET( NMFL_Load,0,Pivots!$FR$1),0.95) and get the same error. However, if I just use the static named range, =PERCENTILE.INC( NMFL_Load, 0.95) it works
Anyone tried this before?
