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
You are not providing nearly enough information. Is this a proprietory
tool which is locked so you cannot alter it? If so you will need to
contact the supplier.
If the tool is a macro or a collection of macros which is not password
protected, or you have the password, then we need to know what c
Hi,
I hope you are looking for the column "M". Please change the formula
reference as "M:M" instead of "A".
Regards,
Saravanan R.
On Wednesday, 13 February 2013 21:40:01 UTC+5:30, hilary lomotey wrote:
>
>
> Hello
>
>
> Pls see attached
>
> HTH
>
>
> On Wed, Feb 13, 2013 at 12:44 PM, Ken
Hi...Job posting is not allowed here
On Thu, Feb 14, 2013 at 11:29 PM, Rajat Ahuja wrote:
> *Please send me resumes at pun...@hmgamerica.com*
>
> *
> *
>
> *Role: Sr. Android Developer*
>
> *Job Location: Huston, TX*
>
> *Preference on Work Authorization: Any*
>
> *Interview Preference: Tel
http://AndaluciaFinancial.com/beauty/asiziWarrickMcKoy.html
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles.
Thanks a lot Ashish for the support.
Regards
Pooja
Sent from BlackBerry® on Airtel
-Original Message-
From: ashish koul
Sender: excel-macros@googlegroups.com
Date: Thu, 14 Feb 2013 21:40:48
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Condition with concate
=IF(A1<>"",IF(MID(A1,2,1)="M",A1&"6012",A1&"6004"),"")
On Thu, Feb 14, 2013 at 9:39 PM, wrote:
> **
> Thanks for this.
>
> One more query, if there are some blank cells in the range of cells on
> which this formula is applied, then is it possible, if an additional
> condition could be applied
Thanks for this.
One more query, if there are some blank cells in the range of cells on which
this formula is applied, then is it possible, if an additional condition could
be applied which can reflect N/A or 0 if the base cell is empty?
Regards,
Pooja Sharma
Sent from BlackBerry® on Airtel
-
Hi,
It may help.
=IF(MID(A1,2,1)="M",A1&"6012",A1&"6004")
On Thu, Feb 14, 2013 at 4:33 PM, wrote:
> Hi There,
>
> I seek for experts guidance on how I can apply a formula, wherein a
> condition is, when a second letter of an alphanumeric code is "M", then
> concatenate the cell with "6012"
Hi There,
I seek for experts guidance on how I can apply a formula, wherein a condition
is, when a second letter of an alphanumeric code is "M", then concatenate the
cell with "6012" otherwise concatenate the cell with "6004".
Regards,
Pooja Sharma
Sent from BlackBerry® on Airtel
--
Are y
Dear All friends,
Pls look on this matter for solution
Regards
Amar
On Thu, Feb 14, 2013 at 11:32 AM, amar takale wrote:
> any solution?
>
>
> On Wed, Feb 13, 2013 at 5:55 PM, amar takale wrote:
>
>> Dear Champs,
>>
>> I here want to update chart when I put data in color cell then
>> automatica
12 matches
Mail list logo
