bmccabe362
New Member
- Joined
- Jan 4, 2010
- Messages
- 11
I have a dataset that where each record has 26 columns of information. My needs require that I query this data in various ways. A typical array formula that I use looks like this: <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>
<o></o>
{=SUM(IF($C$3:$C$800="x",IF($I$3:$I$800>=$AS$32,IF($I$3:$I$800<=$AS$31,IF($K$3:$L$800>=400000,IF($K$3:$L$800<500000,($K$3:$K$800)/$BA$8))))))}<o></o>
<o></o>
Working from front to back, the formula defines criteria for record type, date range, price range and average price within the range. The formula works just fine but I would like to retrieve the files upon which the formulas' data calculation is based. I've tried using the Advanced Filter but with no luck. It seems I understand neither the required format nor the syntax. <o></o>
<o></o>
I also have two related questions: (1) How can I use the above array formula as the basis for conditional formatting? (2) How can I describe the data that was calculated by the above array formula using Quartile Analysis? <o></o>
fficeffice" /><o></o><o
></o>{=SUM(IF($C$3:$C$800="x",IF($I$3:$I$800>=$AS$32,IF($I$3:$I$800<=$AS$31,IF($K$3:$L$800>=400000,IF($K$3:$L$800<500000,($K$3:$K$800)/$BA$8))))))}<o
></o><o
></o>Working from front to back, the formula defines criteria for record type, date range, price range and average price within the range. The formula works just fine but I would like to retrieve the files upon which the formulas' data calculation is based. I've tried using the Advanced Filter but with no luck. It seems I understand neither the required format nor the syntax. <o
></o><o
></o>I also have two related questions: (1) How can I use the above array formula as the basis for conditional formatting? (2) How can I describe the data that was calculated by the above array formula using Quartile Analysis? <o
></o>
