Hi Vaibhav & Paul,
Thanks a lot for your HELP.
On Mon, Jul 21, 2014 at 6:18 PM, Vaibhav Joshi wrote:
> see this...
>
> Cheers!!
>
>
> On Mon, Jul 21, 2014 at 5:53 PM, Dileep Kumar wrote:
>
>> Hi Vaibhav,
>>
>> Thanks a lot for your reply. I found that what mistake I am doing.
>>
>> Is there a
can,
>In all the ways you can,
>In all the places you can,
>At all the times you can,
>To all the people you can,
>As long as ever you can.” - John Wesley
>-------------
>
>
> From: Paul Schreiner
>>To: "excel-macros@googlegroups.com&
>To: "excel-macros@googlegroups.com"
>Sent: Monday, July 21, 2014 8:35 AM
>Subject: Re: $$Excel-Macros$$ Indirect Function Not Working on Dates Please
>Help
>
>
>
> For your sumif(Indirect function in cell B5, try:
>
>=SUMIF(INDIRECT("'"
For your sumif(Indirect function in cell B5, try:
=SUMIF(INDIRECT("'"&TEXT($A5,"dd-mm-")&"'!C18:C40"),B$3,INDIRECT("'"&TEXT($A5,"dd-mm-")&"'!F18:F40"))
(It should copy to D, F, H, J also)
Paul
-
“Do all the good you can,
By all the means you can,
Hi Vaibhav,
Thanks a lot for your reply. I found that what mistake I am doing.
Is there any way that we can give the reference of the date field in the
summary sheet science I have all the sheet with dates only.
That can much faster for me to finish out.
On Mon, Jul 21, 2014 at 5:45 PM, Vaibh
what you are trying to achieve?
On Mon, Jul 21, 2014 at 5:12 PM, Dileep Kumar wrote:
> Dear Friends,
>
> Please find attached Daily Reporting Formate of Excel in the summary sheet
> I am unable to get the vales using indirect function.
>
> Please help me friends.
>
> --
> Regards,
> Dileep Kuma
.
Enjoy
Team XLS
On Sun, Jul 21, 2013 at 12:54 AM, MLT wrote:
> I'm trying to figure out the syntax to use a function within the Indirect
> function. I would like to do something like this but am getting a #REF
> error:
>
> =INDIRECT("SUM(A1:A3)")
>
>
> Where am I goi
Hi,
Use this =VLOOKUP(INDIRECT("A1"),B1:C3,2,FALSE)
** * Best Regards,
Ms Excel User
*
**
On Sun, Jul 21, 2013 at 1:08 AM, MLT wrote:
> cool thanks. can that same syntax be used for vlookup?
>
>
> for example:
>
> =VLOOKUP(INDIRECT("A1,B1:C3,2,FALSE"))
>
> --
> Are you =EXP(
Hi MLT,
Use this =SUM(INDIRECT("A1:A3"))
** * Best Regards,
Ms Excel User
*
**
On Sun, Jul 21, 2013 at 12:37 AM, MLT wrote:
> I'm trying to figure out how to use a function within the indirect
> function. for example, I would like to use a sum function within an
> in
Sent: Thursday, March 01, 2012 2:28 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ indirect function help
Thanks guys...works like a charm.
your all like angles but just more down to earth
On Mar 1, 1:14 pm, NOORAIN ANSARI wrote:
> Dear Selva,
>
> Please see attached sh
Thanks guys...works like a charm.
your all like angles but just more down to earth
On Mar 1, 1:14 pm, NOORAIN ANSARI wrote:
> Dear Selva,
>
> Please see attached sheet, hope your requirement is this.
>
>
>
>
>
>
>
>
>
> On Thu, Mar 1, 2012 at 10:43 PM, LearnExcel wrote:
> > thanks guys, i
Dear Selva,
Please see attached sheet, hope your requirement is this.
On Thu, Mar 1, 2012 at 10:43 PM, LearnExcel wrote:
> thanks guys, is there any reason why the following isnt's working
>
> a6 = sheet name
> h6 = name of the criteria
> **the criteria is a name "Phone"
>
> all i get it 0
>
>
thanks guys, is there any reason why the following isnt's working
a6 = sheet name
h6 = name of the criteria
**the criteria is a name "Phone"
all i get it 0
COUNTIF(INDIRECT("'"&A6&"'!g:g"),INDIRECT("'"&"h6"))
On Feb 29, 5:59 pm, "Asa Rossoff" wrote:
> =SUM(INDIRECT("'"&A6&"'!G:G"))
>
>
>
>
>
=SUM(INDIRECT("'"&A6&"'!G:G"))
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of LearnExcel
Sent: Wednesday, February 29, 2012 2:34 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ indirect function help
HI team, can you ple
Due to spaces in sheet name. I ALWAYS avoid.
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: LearnExcel
Sent: Wednesday, February 29, 2012 4:33 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ indirect function help
HI team, can you please help ou
if we need to know how many Rows Contains data we can use indirect
function like this :
=ROWS(INDIRECT("A1:A"&COUNTA(A:A)))
On Thu, Dec 1, 2011 at 11:19 PM, Aamir Shahzad wrote:
> thanks Noorain / Chethan Kumar.
>
> Regards,
>
> Aamir Shahzad
>
> On Thu, Dec 1, 2011 at 9:03 AM, Dhartikumar Sahu
thanks Noorain / Chethan Kumar.
Regards,
Aamir Shahzad
On Thu, Dec 1, 2011 at 9:03 AM, Dhartikumar Sahu wrote:
> hi chethan
>
> can u explain how u use "getphoto" in Indirect example 3.
>
> Thanks & regards
> Dhartikumar Sahu
>
>
> On Thu, Dec 1, 2011 at 3:07 AM, B.N.Chethan Kumar <
> chetankum
hi chethan
can u explain how u use "getphoto" in Indirect example 3.
Thanks & regards
Dhartikumar Sahu
On Thu, Dec 1, 2011 at 3:07 AM, B.N.Chethan Kumar wrote:
> Hope these help.
>
>
> On Wed, Nov 30, 2011 at 11:47 PM, Aamir Shahzad
> wrote:
>
>> Dear Group,
>>
>> Please provide the "Indirect
Dear Aamir,
The INDIRECT Function
The *INDIRECT* worksheet function is a useful tool for creating cell or
range references "on the fly", as a formula is evaluated, rather than "hard
coding" them into the formula. Microsoft's on-line Help documentation of
this fun
19 matches
Mail list logo
