where is it attached..?
On Thu, Apr 23, 2009 at 2:57 AM, Fabio_XL_Master flnle...@gmail.com wrote:
Hi,
other possible solution is attached. Using offset and Array formula.
Fabio
--~--~-~--~~~---~--~~
I am enclosing the excel file without a macro. Hope the same serves your
purpose.
Bye and with best wishes
N.SHIVKUMAR
Mobile : +919866533180
Office : +914027685423
Res.: +914040035774
Alternate Email: shiv1...@yahoo.com
--~--~-~--~~~---~--~~
use the sum product formula:
the derived formula is
=SUMPRODUCT(($D$2:$D$6)*($A$2:$A$6=$A13)*($C$2:$C$6=C$12)).
Pls check the attached excel sheet that I have prepared, for your help.
On Thu, Apr 23, 2009 at 1:37 AM, gabo gabo22...@yahoo.com wrote:
I have a spreadsheet where I need to
Excel (upto 2003 version) only allows 3 conditions and sometimes you can put
4th conditon (default condition-the condition that exits by default).
In case you want to put more conditions then you'll have to use VBA as an
alternate or upgrade to Excel 2007.
On Thu, Apr 23, 2009 at 1:29 AM, Sam K
Hi gabo,
it is possible to let look like the data of the upper example like yours
below.
Take a look in the Excel help by searching for Pivot Table
Regards,
Sergio
2009/4/23 gabo gabo22...@yahoo.com
I have a spreadsheet where I need to combine some rows into columns.
Listed below is an
Hello Sergio,
Thanks for your support, the file sent by you has a great start.
What I want is, Bank calculate Interest quarterly, now if I have taken FD on
20 May then Bank will calculate interest from 20 May to 20 Aug. As Interest
is getting compounded qyarterly. But for our accounting we want
U can also use paste special function...write 1000 in a cell...copy
it...select the data to be dividedthen
paste special...formuladivide.
Hope that it will serve the purpose...
2009/4/23 N.Shivkumar shiv1...@gmail.com
I am enclosing the excel file without a macro. Hope the same
hi i need to find the difference between 8:45:28 PM 10:41:00 PM i want it
to be a logical function like if the difference is more than say one hour is
want it to get yes or else no
On Thu, Apr 23, 2009 at 11:44 AM, Suryaprasad.bv
suryaprasad...@gmail.comwrote:
where is it attached..?
On
Mr. Roopesh,
The calculatiion sent in your sheet is not matching by the calculation done
by Bank. The sheet which I have attached is actually as per the Bank
calcualtion only.
Ashish.
On Wed, Apr 22, 2009 at 8:08 PM, Roopesh Kapur roopesh.ka...@gmail.comwrote:
Readers,
No doubt the
See attached file
On Thu, Apr 23, 2009 at 3:38 PM, mathew darryl matt.attitud...@gmail.comwrote:
hi i need to find the difference between 8:45:28 PM 10:41:00 PMi want it
to be a logical function like if the difference is more than say one hour is
want it to get yes or else no
On Thu,
one more solution is attached
On Thu, Apr 23, 2009 at 7:22 PM, Harmeet Singh harmeet.hew...@gmail.comwrote:
See attached file
On Thu, Apr 23, 2009 at 3:38 PM, mathew darryl
matt.attitud...@gmail.comwrote:
hi i need to find the difference between 8:45:28 PM 10:41:00 PMi want
it to be a
On Thu, Apr 23, 2009 at 12:09 PM, Sergio Abadesso
groups.abade...@googlemail.com wrote:
Hi gabo,
it is possible to let look like the data of the upper example like yours
below.
Take a look in the Excel help by searching for Pivot Table
Regards,
Sergio
2009/4/23 gabo
Hello Ashish and Roopesh,
I'm currently working on a solution that contains all the data like they are
in the Worksheets of Ashish.
In the next step we can also implement the details that you Mr. Roopesh
mentioned.
I will continue on the sheet after work.
Regards,
Sergio
2009/4/23 Ashish got
I'm sorry...
here is the attachment
2009/4/23 Suryaprasad.bv suryaprasad...@gmail.com
where is it attached..?
On Thu, Apr 23, 2009 at 2:57 AM, Fabio_XL_Master flnle...@gmail.comwrote:
Hi,
other possible solution is attached. Using offset and Array formula.
Fabio
--
Fabio L
Dear All
i herewith attach the sample file on which i want to work,i took script from
Mudassar Ramzans File which he posted to this group, i have already go
through the code, but i have all my data on sheet1, when i run the macro
it dont get connect to *MS Outlook* or cursur moves to
Your task is to write a small macro that converts the seat list into a
seat chart in table 2.
First, the names in table 1 are in Last_Name, First_Name format. You
need to convert them into First_name Last_name format to place in
table 2. To do this, you need to write a function called ConvertName
Hello Everyone,
Finally With all your support and good wishes we have complete 4000
Members in our Google group and is ranked # 1 in world of Excel and
macros Google groups.
Our SPECIAL thanks to all those who are helping members by their good
knowledge of Excel and VBA Macros.
Keep Posting !!
Hi Dustin,
You have to use the 'Cells' thingy instaed of the 'Range' thingie. Then you can
use variables. But you have to use Column numbers, not Column letters, and you
have to put the Row first, then the Column, separated by a comma.
Example:
YourRow=5 'Row
YourCol=3'Column
Hi ,
try this code
Dim appWord As Word.Document, aadoc
set appWord = getobject(FileName)
'copy picture from excel
For Each objShape In ActiveSheet.Shapes
objShape.Select
With objShape
.Height = intHeight
.Width = intWidth
.Copy
End
Just try this
Worksheets(RAW).Range(A4701:CE4900).Copy _
Destination:=Worksheets(ExecServices).Range(A iNextRow:CE
iNextRow)
Date: Thu, 23 Apr 2009 10:54:34 -0700
Subject: $$Excel-Macros$$ Macro Help
From: dustin.ho...@gmail.com
To: excel-macros@googlegroups.com
Okay guys, I
20 matches
Mail list logo