Hi Deepak,
you also try this one
=SUMIF($A$2:$A$9,"Snickers ",B2:B9)+SUMIF($C$2:$C$10,"Potato",D2:D10)
On Wed, Jul 17, 2013 at 7:46 PM, ashish koul wrote:
> =SUMPRODUCT(($A$2:$A$9="Snickers
> ")*($B$2:$B$9)+($C$2:$C$9="Potato")*($D$2:$D$9))
>
> see if it helps
>
>
>
>
> On Wed, Jul 17, 2013
Hi
I am not able to access the ImportAccess.zip folder that you have send
across. Please look into the issue.
Thanks & regards,
*Sandeep Kumar Baranwal*
Business Analyst
Credit Risk Methodology & Wholesale Basel,Genpact
Gurgaon
India
Mob:-+91-8588802543
On Wed, Jul 17, 2013 at 8:59 PM, Basole
try the attached file see if it helps. make changes in the macro as per
your requirement
On Mon, Jul 15, 2013 at 11:04 AM, Rajan sharma wrote:
> Dear All,
>
>How can we plot the data below in chart. i am expecting the chart as
> like in attached file. plse find the attachment.
>
>Type T
Hi
Kindly note that sql.request is functional in MS Excel 2007 but not in MS
Excel 2010. Could you please let me know any VBA code that would be a
substitute for sql.request.
If yes, Please let me know with the help of an example.
We use sql.request to transfer data from MS Access to MS Excel in v
check this out http://www.geocities.jp/kenj_uda/en/Ray.html
On Tue, Jul 16, 2013 at 7:09 PM, Mog Godiva-Man wrote:
> Hi experts,
>
> Does anyone know how to write a macro to create a skyline chart very
> basic. Based on date.
>
> Thanks,
> Godiva
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) i
Sub sample()
Sheets(1).Range("a65356").End(xlUp).CurrentRegion.Copy
Sheets(2).Range("a65356").End(xlUp).Offset(1, 0)
End Sub
On Wed, Jul 17, 2013 at 8:00 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hi,
>
> Thanks for your reply. I need to know which is the last range and pas
Hi,
Thanks for your reply. I need to know which is the last range and paste it
in sheet2. Is there anyway to do this.
Please find attached updated excel & there will be many ranges in sheet1
but I should know which is last range and paste same in sheet2.
Regards,
Chandra
On Wed, Jul 17, 2013
can you share the sample files
On Wed, Jul 17, 2013 at 6:11 PM, chenna reddy wrote:
> Hi All,
>
> I am looking for a macro by which i Can import all the review comments in
> a document (word,Excel,PDF,Visio) in to a Excel sheet.
>
> Features I am looking for:-
>
> 1. Select a document by browsin
=SUMPRODUCT(($A$2:$A$9="Snickers
")*($B$2:$B$9)+($C$2:$C$9="Potato")*($D$2:$D$9))
see if it helps
On Wed, Jul 17, 2013 at 7:33 PM, Deepak Singh wrote:
>
>
> Hi all,
>
> I want total Calories of Snickers and Potato from below data ..Output is
> 1150, please solve..
>
>
> *ColumnA ColumnB
try this
Sub abc()
MsgBox ActiveCell.SpecialCells(xlLastCell).CurrentRegion.Address
End Sub
On Tue, Jul 16, 2013 at 8:44 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hi,
>
> How to know how many ranges are there in the attached workbook and how to
> select last range using Area
Hi all,
I want total Calories of Snickers and Potato from below data ..Output is
1150, please solve..
*ColumnA ColumnB Column C Column D*
Candy Calories Fruits & Vegetables Calories Snickers 350 Tomato 10
Twix 370 Potato 40 Skittles 450 Tomato 30 Snickers 35
Hi Sir,
I checked the same main time but In-vain it can not shows the results in
the attendance details calculator. Request you to kindly assist me in
briefly
*Regards*
On Wed, Jul 17, 2013 at 5:58 PM, P.VIJAYKUMAR wrote:
> Respected Vikas,
>
> There is no problem with the tracker.Just enable
Respected Kaushal,
If the file is hidden through a standard windows query you can go to the
properties tab and uncheck the hide button to unhide the sheet.Sometimes it
may be encrypted or user permissions to open or modify the file may be
restricted by the system administrator or the owner of the
Hi Kausal,
This is not possible to hide all sheets in excel. atleast one file should
be visible. i hope the rows and colums are hidden.
just check u can see the sheet names in that file. if so then just try to
unhide the rows and columns.
To unhide the rows and columns:
in 2007 verson : Goto "H
Respected Anil,
The dashboard is wonderful and fabulous.If you have designed it yourself
you are a top class excel genius and a excel expert.
Thanking you once again for the Dashboard.
Regards,
VijayKumar
On Wed, Jul 17, 2013 at 2:10 PM, अनिल नारायण गवली
wrote:
> Dear Rajesh,
>
> Pl see the a
Hi Vijay,
File was hidden from the standard window command. Praveen has already answered
this query.
Thanks & Rgds,
Rgds, Kaushal
-Original Message-
From: "P.VIJAYKUMAR"
Date: Wed, 17 Jul 2013 12:56:25
To:
Subject: Re: Fwd: $$Excel-Macros$$ Un hide a workbook
Respected Kaushal,
Respected Kaushal,
I think that the file is saved as read only and modifications and editing
are prohibited.The procedure of saving the excel file or any office file as
read only is as per the following link
http://support.microsoft.com/kb/214094.You can see the file but hen you
open the file the
Respected Neeraj,
Excel stores all dates as integers and all times as decimal fractions. With
this system, Excel can add, subtract, or compare dates and times just like
any other numbers, and all dates are manipulated by using this system.Times
are stored as decimal numbers between .0 and .9,
Hi All,
I am looking for a macro by which i Can import all the review comments in a
document (word,Excel,PDF,Visio) in to a Excel sheet.
Features I am looking for:-
1. Select a document by browsing local files.
2. Import review comments from the file selected to a Excel .
3. Clear review commen
It's awesome.
-- Forwarded message --
From: Anonymous
Date: Wed, Jul 17, 2013 at 5:57 PM
Subject: $$Excel-Macros$$ Re: Help Required
To: excel-macros@googlegroups.com
Hi All,
I've found a more simpler way to get the time in hrs and minute..
And yes i've seen all ur tricks for
Apologies, I can not share that file
Rgds, Kaushal
-Original Message-
From: Pravin Gunjal
Date: Wed, 17 Jul 2013 12:26:18
To:
Subject: Fwd: $$Excel-Macros$$ Un hide a workbook
post the file at group.
-- Forwarded message --
From: Kaushal Kumar mailto:kaushal.anal...
Respected Vikas,
There is no problem with the tracker.Just enable the macros of excel.For
inputting any new data do not type manually but use the button given and
type the data into the dialogue box you get after pressing the button.
**
Regards,
VijayKumar
--
Are you =EXP(E:RT) or =NOT(EXP(E
Hi All,
I've found a more simpler way to get the time in hrs and minute..
And yes i've seen all ur tricks for this..i dnt know where my trick
fails...but i am getting the desired output via my trick also..
so its a question just out of curiosity that my trick is wrong or not, and
if it's wro
post the file at group.
-- Forwarded message --
From: Kaushal Kumar
Date: Wed, Jul 17, 2013 at 5:54 PM
Subject: $$Excel-Macros$$ Un hide a workbook
To: Excel VBA Group
Dear All,
When I am opening an excel file it seems it is open but not visible. Seems
like entire workbook is
Dear All,
When I am opening an excel file it seems it is open but not visible. Seems like
entire workbook is as been hidden.
Can someone please help how can we retrieve that file.
Rgds Kaushal
Rgds, Kaushal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIM
Hi
pfa
Anil Kumar
From: Neeraj Chauhan
To: excel-macros@googlegroups.com
Sent: Wednesday, 17 July 2013 3:41 PM
Subject: $$Excel-Macros$$ Help Required
Dear experts,
How to subtract time in hours and minute
10:30 AM - 10:30 PM
=
Thank
Please find attachment.
it might help you
On 7/17/13, Neeraj Chauhan wrote:
> Dear experts,
>
>
>
> How to subtract time in hours and minute
>
>
>
>
> 10:30 AM
>
> - 10:30 PM
>
> =
>
>
>
>
>
> Thanks & Regards
>
> Neeraj Chauhan
>
> +91-9756706350
>
> neerajchauhan...@gmail.com
>
>
>
> -
Any Hope?
Regards
On Tue, Jul 16, 2013 at 9:20 PM, Bé Trần Văn wrote:
> File your reference, the noorain.ansari
>
> 2013/7/16 vikas khen
>
>> Hi Team,
>>
>> Expecting replay on this mail as It will very helpful for me
>>
>> Regards
>>
>>
>> On Thu, Jul 11, 2013 at 1:43 PM, vikas khen wrote:
Dear experts,
How to subtract time in hours and minute
10:30 AM
- 10:30 PM
=
Thanks & Regards
Neeraj Chauhan
+91-9756706350
neerajchauhan...@gmail.com
--
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
Hello everyone
Is there anyone in the group having macro calculation sheet for indian
stock or commodity market. If yes, I request to share with us.
Rgds.
--
*Rajesh Kumar Agarwal*
*9811063001*
--
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) ! J
30 matches
Mail list logo
