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
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$$ How
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$$
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
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;
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@googlegroups.com]
On
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
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:
)
find the attachment I have mentioned the examples .
Regardas,
Prafull Jadhav.
MIS Executive.
On Sat, Apr 6, 2013 at 1:53 PM, Priti_verma pritiverma1...@gmail.com
wrote:
Hi Amar ,
There is no difference between these formulas.if u have any doubt please
mention your query
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
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,
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:
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
Priti Verma
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,
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
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: 12
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 extract All word in
noorain.ans...@gmail.com
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
pritiverma1...@gmail.com
wrote:
Hi,
To all,
I am new here,please help me
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,
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,
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
23 matches
Mail list logo