Percentile ranges

**Santhoshhrishi** · 07-11-2014, 08:56 AM

Hi Team,

How can i keep the source data & percentile ranges in two different sheets & keeping them linked. I require this because would need ranges for multiple scenarios with same data.

Have attached sample file fyr., pl help in arriving at this.

Thanks in advance.

**Speshul** · 07-11-2014, 09:08 AM

I noticed on the Data! tab some formulas are array, some are not. Which should it be?

Your second tab Percentile Ranges, the formulas do not reference the same sheet and ranges as the table on the Data tab, try
in Cell K4 on Percentile Ranges:

=PERCENTILE.INC(IF(($D$2:$D$3500=$I4)*($F$2:$F$3500=$J4),$G$2:$G$3500,FALSE),K$3)

**Santhoshhrishi** · 07-11-2014, 09:59 AM

Ok. just dont consider my sheet 2. I want data to be in one sheet & percentile ransges for the same data in a different sheet. Is that possible if so pl let me know how can i arrive at it.