software

I’m having a scaling issue…
=QUARTILE(Sheet1!$C$2:$C$45,A3) works well!
A3 resides on sheet2.
Also on sheet2, resides =COUNTA(Constructs!P2:P10000) in cell Q1
I’m trying to use INDIRECT to scale the Quartile formula.
Here’s what I’ve got that’s not working:
=QUARTILE(Sheet1!$C$2:indirect(Sheet1!quot;Cquot;amp;Q1,A4))
Can this indirect method be used for quartile?
Uuuugh!
Arturo

Try

=QUARTILE(Sheet1!$C$2:INDIRECT(quot;'Sheet1'!Cquot;amp;Q1),A4 )
--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;Arturoquot; gt; wrote in message
...
gt; I'm having a scaling issue.
gt; =QUARTILE(Sheet1!$C$2:$C$45,A3) works well!
gt; A3 resides on sheet2.
gt; Also on sheet2, resides =COUNTA(Constructs!P2:P10000) in cell Q1
gt; I'm trying to use INDIRECT to scale the Quartile formula.
gt; Here's what I've got that's not working:
gt; =QUARTILE(Sheet1!$C$2:indirect(Sheet1!quot;Cquot;amp;Q1,A4))
gt; Can this indirect method be used for quartile?
gt; Uuuugh!
gt; Arturo
Try this:

=QUARTILE(INDIRECT(quot;Sheet1!$C$2:$C$quot;amp;Q1),A4)

quot;Arturoquot; wrote:

gt; I’m having a scaling issue…
gt; =QUARTILE(Sheet1!$C$2:$C$45,A3) works well!
gt; A3 resides on sheet2.
gt; Also on sheet2, resides =COUNTA(Constructs!P2:P10000) in cell Q1
gt; I’m trying to use INDIRECT to scale the Quartile formula.
gt; Here’s what I’ve got that’s not working:
gt; =QUARTILE(Sheet1!$C$2:indirect(Sheet1!quot;Cquot;amp;Q1,A4))
gt; Can this indirect method be used for quartile?
gt; Uuuugh!
gt; Arturo