thanx Noorani got the answer
Date: Sat, 30 Jun 2012 23:18:16 +0530
Subject: Re: $$Excel-Macros$$ tricky some question
From: noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Dear Danial,
Please use
=Get.cell(21,indirect("RC[1]",) and create Name range.
then
2012 23:38:05 +0530
Subject: Re: $$Excel-Macros$$ tricky some question
From: noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Dear Danial,
Please see attached workbook, It's working fine in it.
For right reference you use..it
=Get.cell(21,indirect("RC[1]",)
and for Left r
dguille...@gmail.com
From: NOORAIN ANSARI
Sent: Saturday, June 30, 2012 12:48 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ tricky some question
Dear Danial,
Please use
=Get.cell(21,indirect("RC[1]",) and create Name range.
then use simple
=SUMPRODUCT(($A$5:$A$9=
e to do manual sum as i did in a given sheet and it is hectic job i have
huge data plz help.
Date: Sat, 30 Jun 2012 22:50:29 +0530
Subject: Re: $$Excel-Macros$$ tricky some question
From: noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Dear Mansoor
Please share your workbook with
is hectic job i
> have huge data plz help.
>
>
> --
> Date: Sat, 30 Jun 2012 22:50:29 +0530
> Subject: Re: $$Excel-Macros$$ tricky some question
> From: noorain.ans...@gmail.com
> To: excel-macros@googlegroups.com
>
>
> Dear Mansoor
>
Dear noorani,
i have attached a sample sheet hope you get idea from the given sheet,i will
have to do manual sum as i did in a given sheet and it is hectic job i have
huge data plz help.
Date: Sat, 30 Jun 2012 22:50:29 +0530
Subject: Re: $$Excel-Macros$$ tricky some question
From
Dear Mansoor
Please share your workbook with group.
It is possible through Get.Cell Function in Excel.
On Sat, Jun 30, 2012 at 3:38 PM, danial mansoor wrote:
>
> Dear Experts,
>
> i have 2 heads of utilities one is bold and another is in general form and
> i have a bunch of data with same forma
