Thanks Sekar,I will wait for your reply
On Sat, Feb 16, 2013 at 8:40 AM, RAJA SEKAR wrote:
> Dear Amit,
>
> for min and Max for Entire Range use
>
>
> MIN(R_S1) & MAX(R_S1) @ ADJ CloseColumn
> Min (R_S2) & MAX(R_S2) @ Relative Performance Column
>
> let me to work out on rest
>
>
> On 15 Fe
Dear Amit,
for min and Max for Entire Range use
MIN(R_S1) & MAX(R_S1) @ ADJ CloseColumn
Min (R_S2) & MAX(R_S2) @ Relative Performance Column
let me to work out on rest
On 15 February 2013 14:17, amar takale wrote:
> Dear Sekar,
>
> Great!
> Thanks a lot,extact which work I want through
Dear Amar,
In this file we have applied logic of "Min" as indicator to fix the range,
i.e., "Min" is located in F 57 in attached file and range is arrived 57 -2
(55th) row.
you can use *CountA($A:$A)-1* instead of *MATCH("MIN",ABB!$F:$F)-2*
On 15 February 2013 11:11, amar takale wrote:
> T
Hi Sekar,
Thank y very much this kind of solution,but still I confused why space
between two rows, if do that then in line chart show little gap to touch
axis.I want to after paste data automatically chart update to current
date,here also I do expand range manually min & max.Pls guide me.
Regards
A
