try this
Range("T2").FormulaR1C1 =
"=COUNTIF(RC17,""<94"")+COUNTIF(RC18,""<89"")+COUNTIF(RC19,""<90"")" _
&
"+COUNTIF(RC12,"">3.46"")+COUNTIF(RC13,"">2.82"")+COUNTIF(RC14,"">2.44"")+COUNTIF(RC15,"">2.31"")+COUNTIF(RC16,"">2.67"")"
On Friday, March 2, 2018 at 10:07:27 PM UTC+5:30, Johnny wro
Hi chaya ,
Yes you can do it.Please see the attached file .
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chaya
Sent: 10 May 2013 9:51
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Split with formula
Hi Priti,
Sorry for
Hi Rakesh ,
Please see the attached file.To Find the solution of your problem.
Regards
Priti verma
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Gaurav Garg
Sent: 17 April 2013 5:31
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ H
Hi Rakesh ,
Please see the attached file.To Find the solution of your problem.
Regards
Priti verma
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Gaurav Garg
Sent: 17 April 2013 5:31
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How
Hi Kuldeep
I think this formula fullfil your requirement.
=ROUNDUP((A2*2)/10,0)*10/2
Regards
Priti verma
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kuldeep Singh
Sent: 16 April 2013 8:17
To: excel-macros@googlegroups.com; excelvbacli...@googleg
So what do you need ??
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Amit Desai (MERU)
Sent: 16 April 2013 11:02
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Column Reference based on changes in Raw reference
Dear Group,
I need yo
Hi Arjun
Use this formula
=VLOOKUP("??/??/??",TRIM(MID(SUBSTITUTE(A45," ",REPT("
",LEN(A45))),((ROW(INDIRECT("1:"&LEN(A45)))-1)*LEN(A45))+1,LEN(A45))),1,0)
Enter as a array formula
Regards
Priti verma
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ash
Hi Aamar,
Please Try This Formula Hope this will help u
=IF(ISERROR(INDEX(INDIRECT($C$3&"!L:L"),MATCH($C7,INDIRECT($C$3&"!K:K"),0)))
,"",INDEX(INDIRECT($C$3&"!L:L"),MATCH($C7,INDIRECT($C$3&"!K:K"),0)))
Regards
Priti verma
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegr
="&B3)
find the attachment I have mentioned the examples .
Regardas,
Prafull Jadhav.
MIS Executive.
On Sat, Apr 6, 2013 at 1:53 PM, Priti_verma
wrote:
Hi Amar ,
There is no difference between these formulas.if u have any doubt please
mention your query with example.
R
See = is a comparison operater in countif which is default for this function
.so doesn't matter if we are using = in our function or not.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Abhishek Jain
Sent: 06 April 2013 1:51
To: excel-macros@googlegrou
Hi Amar ,
There is no difference between these formulas.if u have any doubt please
mention your query with example.
Regards,
Priti Verma
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: 06 April 2013 1:47
To: excel-macros@googlegroups.
Hi Amar ,
Please find the attachment . Hope this will help you.
Regards,
Priti verma
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: 05 April 2013 5:34
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Range Solution
De
Hi,
Please try this
=DATE(YEAR(B3),MONTH(B3)+1,7)
Regards
Priti verma
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of L.K. Modi
Sent: 04 April 2013 4:50
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ due date formula
Dear all
can an
Hi ,
I am also new in vba and I know little bit about this
These all are known as variables and used to return our result in a specific
pattern like string , number , etc.
suppose we want our result in string pattern we have to declare it in
string.
Ex-
dim strresult as string
Regards,
Prit
Hi ,
I am new on this group I have query plz help me?
Hi!
I have a repayment schedule, the monthly instalments are in a row (eq from
E7 -> E250) and I must to transpose these values in a row, in other sheet
(from D5 -> AX5);
I don't want to use Copy - paste special...I have tried with to use "$
Try this in C15:I15 as array
=TRANSPOSE(OFFSET(INDEX($C$5:$N$5,1,MATCH(C14,$C$5:$N$5,0)),1,0,6,1))
Priti
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: 04 August 2012 1:18
To: excel-macros@googlegroups.com
Subject: $$Excel-Macro
Hi
Use this .. no matter with how many number text started J
=TRIM(MID(C7,MAX(--ISNUMBER(VALUE(MID(C7,ROW(INDIRECT("1:"&LEN(C7))),1)))*RO
W(INDIRECT("1:"&LEN(C7+1,LEN(C7)-MAX(--ISNUMBER(VALUE(MID(C7,ROW(INDIREC
T("1:"&LEN(C7))),1)))*ROW(INDIRECT("1:"&LEN(C7)) with CSE
Pri
Hi ,
I hope this will help u
=INDEX($A$1:$C$6,MATCH(E16,$B$1:$B$6,0),1)
And see the attach file
Priti verma
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem,
Hi
I hope this formula will help u
=INDEX($A$1:$C$6,MATCH(E16,$B$1:$B$6,0),1)
And see the attach file.
Priti
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, C
Hi,
Use this array formula to get 1st filled cell value in a range.hope it will
help you
=INDEX($A$1:$A$5,LARGE(--(A1:A5<>"")*ROW(A1:A5),SUM(--(A1:A5<>""))),1)
Priti verma
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent:
Hi muneer ,
See the attach file. I think it will help you.
You can use the formula:
=trim(mid(substitute(" "&trim (a2)," ",rept(" ",250)),n*250,250))
Where
N=2,3,4,5,,6,7,8.
Regards priti verma
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise,
AIN ANSARI
>
> wrote:
>>
>> or Use.. below formula with ctrl+shfit+enter
>>
>> =SUM(IF(($A$2:$A$1010=$K$9)*($B$2:$B$1010=L$10)*($C$2:$C$1010=$K11),(
>> $F$2:$F$1010),"")
>>
>> On Wed, Jul 11, 2012 at 3:30 PM, Priti_Verma
>>
>> wrot
Hi Muneer
To Extract 1st Word use this : =LEFT(A2,FIND(" ",A2,1)-1)
To Extract Last word use this : =MID(A2,FIND("*",SUBSTITUTE(A2,"
","*",LEN(A2)-LEN(SUBSTITUTE(A2," ","",LEN(A2)-FIND("*",SUBSTITUTE(A2,"
","*",LEN(A2)-LEN(SUBSTITUTE(A2," ",""+1)
I think the better way is to extr
Hi, Muneer , I want to ask u ,which word u want to extract , last or middle
Regards
Priti verma
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mohammed Muneer
Sent: 10 July 2012 7:56
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Ex
Please see the attached file
Good information on this site about IST and BST:
http://wwp.greenwichmeantime.com/to/ist/to-bst/index.htm
__
Regards
Priti Verma
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Pooja Sharma
Sent: 07 July 20
Hi All,
I am new to excel , I just wanted to know how excel offset function works?
__
Regards
Priti Verma
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem,
26 matches
Mail list logo