Ashish, this solution is brilliant and will work. Thank you.
What it says though is that you first have to pull that data needed into a
different table and then chart on that new table. I assume then that
there's no way (without using pivots) to put the filtering into the
=SERIES() that the ch
Dear Ashish Sir,
Thanks a lot .
Regards,
Prafull Jadhav.
On Thu, Apr 4, 2013 at 11:00 PM, ashish koul wrote:
> Its an array formula so u have to enter with CTRL+SHIFT+ ENTER
>
> iFERROR(SMALL(IF($B$2:$B$16=$G$2,$A$2:$A$16,""),ROW(A1)),"")
>
> Lets break the formula
>
> IFERROR - It check if th
Its an array formula so u have to enter with CTRL+SHIFT+ ENTER
iFERROR(SMALL(IF($B$2:$B$16=$G$2,$A$2:$A$16,""),ROW(A1)),"")
Lets break the formula
IFERROR - It check if the value passed is error then you have to specify
what would you like to show in case you pass error
For example if below for
Dear Ashish Sir,
Can you explain the below formula ..what is "Small" function work here.
=IFERROR(SMALL(IF($B$2:$B$16=$G$2,$A$2:$A$16,""),ROW(A1)),"")
Regards,
Prafull Jadhav
On Thu, Apr 4, 2013 at 10:40 PM, ashish koul wrote:
> Try this one too without pivot table .
>
>
> On Thu, Apr 4, 201
Try this one too without pivot table .
On Thu, Apr 4, 2013 at 10:11 PM, ashish koul wrote:
> you can try pivot charts . Find the sample file attached. Just select the
> day in the report filter
>
>
>
> On Thu, Apr 4, 2013 at 10:03 PM, Chris wrote:
>
>> I have data by day for an entire year. A
you can try pivot charts . Find the sample file attached. Just select the
day in the report filter
On Thu, Apr 4, 2013 at 10:03 PM, Chris wrote:
> I have data by day for an entire year. A date in column A, the weekday
> (Mon, Tue, Wed, etc.) in column B and a value in column C.
>
> Somewhere e
I have data by day for an entire year. A date in column A, the weekday
(Mon, Tue, Wed, etc.) in column B and a value in column C.
Somewhere else on the spreadsheet, let's say D1, I enter the weekday into
the cell. I would the like a chart to ONLY use the rows in the entire
table that have that
