I am sending you excel sheet after filtering only gold, but exchange
provide daily bhav copy of all the commodities and i want to pick out near
months commodities like gold, silver, copper and many more so i asking you
how to put vlookup in gold.
thanks
On Friday, March 30, 2012 8:39:43 PM
Dear All,
Could you please help me with a formula?
Attached is a sample file where in I need in column (W, X Y) Invoice date,
Invoice Number Inv. Amount for each cab's previous last visit. Similarly I
need in column (Z, AA AB) Invoice date, Invoice Number Inv. Amount for each
cab's
Dear Shrini
Plz find out solve attach file.
Regards
LAKSHMAN
From: Shrinivas Shevde shrinivas...@gmail.com
To: excel-macros@googlegroups.com
Sent: Monday, April 2, 2012 12:44 PM
Subject: $$Excel-Macros$$ Count formula
Dear all ,
I have a software which takes
It's a custom format for
532 to covert in 5:32
Please try
#:##
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of pawel lupinski
Sent: Mar/Tue/2012 07:36
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ format a cell
Hi All,
Hi,Please help me.
I have following Data
Sheet1 Sheet2
Date Amount Month ( I am storing this field on
seperate sheet),*I need formula to sum for the spcific Month,changing value
of month in Sheet2*.
01/04/2012106
Say I want to open a file with the below location or open the below link.
What is the VBA code for this ?
C:\Users\user\Desktop\leads.xls
or open this link
C:\Users\user\AppData\Local\Google\Chrome\Application
ty,
Alex
--
FORUM RULES (986+ members already BANNED for violation)
1) Use
# \ : ##
Dear Rajan use this,
Regards,
Muneer,
CC...
--
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, Code Problem, and Need Advice will not get
quick
for January use 1 in cell a1
=sumproduct((month(sheet1!a2:a200)=a1)*sheet1!b2:b200)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: ASHOK PHALKE
Sent: Monday, April 02, 2012 2:55 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ CONDITIONAL SUM
One way to learn is to record a macro while doing manually
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Kremstep
Sent: Sunday, April 01, 2012 11:19 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Opening Files or Links using VBA Code Ref: 816
If desired, reply directly to me with your file.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: rajeyssh
Sent: Monday, April 02, 2012 2:08 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ vlookup with more than one value
I am sending you excel
Hi group,
I have just created formula to extract unique List from a given Range, it's
an array formula.
Just sharing with group J
=IFERROR(INDEX(Range,SMALL(LARGE(--(COUNTIF(INDIRECT(A1:A
ROW(Range)),Range)=1)*ROW(Range),ROW(INDIRECT(1:
SUM(1/COUNTIF(Range,Range),ROW(INDIRECT(1:
Workbooks.open(YourFilePath)
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kremstep
Sent: Apr/Mon/2012 09:50
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Opening Files or Links using VBA Code Ref: 816
Say I want to open a
My Try,
Array formula, {=SUM(--(MONTH(Sheet1!A2:A7)=A1)*Sheet1!B2:B7)}
Regards,
MARIES.
On Mon, Apr 2, 2012 at 5:47 PM, dguillett1 dguille...@gmail.com wrote:
=sumproduct((month(sheet1!a2:a200)=a1)*sheet1!b2:b200
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise,
Hi
Please find attached workbook
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ASHOK PHALKE
Sent: Apr/Mon/2012 01:26
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ CONDITIONAL SUM
Hi,Please help me.
I have following Data
Hi Rajan,
It gives duplicates as well.
You may try this shorter one.
In E2 and copied down,
=INDEX(Range,MATCH(0,COUNTIF($E$1:E1,Range),0))
Array formula.
Kris
On Monday, 2 April 2012 19:19:58 UTC+5:30, Rajan_Verma wrote:
Hi group,
I have just created formula to extract unique List
PFA.
Kris
On Monday, 2 April 2012 19:51:01 UTC+5:30, Rajan_Verma wrote:
Hi Krishna,
Can you share a scenario where its giving duplicates?
Rajan.
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Kris
*Sent:* Apr/Mon/2012 07:42
*To:*
Hi krish
Please see attached sheet..I am unable to understand y its giving duplicate
to you only
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kris
Sent: Apr/Mon/2012 07:59
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
Insert a row before Row 1.
On Monday, 2 April 2012 20:06:06 UTC+5:30, Rajan_Verma wrote:
Hi krish
Please see attached sheet..I am unable to understand y its giving
duplicate to you only
Rajan.
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On
Ok Got it.. thanks
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kris
Sent: Apr/Mon/2012 08:16
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Formula to Extract Unique Values :
Insert a row before Row 1.
On Monday, 2 April
hi group,
i wants to create addin in excel. i have created a addin using below
steps, but it is not working.
1. in new workbook, i have insert a module and macro codes in it.
2. then saved the same workbook using .xlam extension.
3. when i opens the same add in in new excel. it does not
Hello
I need a bit of a help with the attached excel file. (Formula would be
best as I want to avoid the use of Macros / VBA)
The attached excel file has two sheets:
Cheque Entries Sheet:
I shall be inserting data in Columns E, F, G, H and I on a regular
basis. (Entries shall also be made
Add-ins are designed to run in the background, and hence the file will not
be visible when you open it. If you go to the VBE window, you could
actually see that the vba project for your add-in is shown.
Sam Mathai Chacko
On Mon, Apr 2, 2012 at 10:50 PM, Raj Mahapatra rajafs...@gmail.com wrote:
sam, how would i get that add in as a tab in ms excel
Thanks Regards
Rajesh Mahapatra
On Mon, Apr 2, 2012 at 10:57 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Add-ins are designed to run in the background, and hence the file will not
be visible when you open it. If you go to the VBE
Dear Raj,
Please visit here.
http://www.ozgrid.com/VBA/excel-add-in-create.htm
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
On Mon, Apr 2, 2012 at 10:50 PM, Raj Mahapatra rajafs...@gmail.com wrote:
Hi
Add-in will not looks like a opened file .. it will installed in your excel
application, if you want to see you add-ins is installed properly .. you can
press ALT +I , a dialogue box will open which will show all add-in available
for you application.. you can use the macro written in that
I think u should create custom menu to display that in Ribbon
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Raj Mahapatra
Sent: Apr/Mon/2012 11:30
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Add-in creation in excel 2007
Hi Mohammed,
There are several possibilities that come to mind.
You can try the following approach, or if this does not do what you want,
provide a sample file and I/we will try to give you a different suggestion
for your specific situation.
1. Remove all existing subtotals, totals,
This link will tell you how to add a tab in Excel
http://www.excelfox.com/forum/f10/how-add-new-ribbon-tab-excel-26/?highlight=ribbon
Regards,
Sam Mathai Chacko
On Mon, Apr 2, 2012 at 11:40 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
I think u should create custom menu to display that in
Hi Raj,
Check below link,
http://jackmcintyre.net/how-to-add-macros-to-the-excel-2007-ribbon/
Dear Friends,
Anyone give more details about Custom UI Editor
Toolhttp://openxmldeveloper.org/articles/CustomUIeditor.aspx.
From above link, I came to know we required Custom UI Editor
The Custom UI Editor Tool is used to modify the XML tag of the custom UI
xml files on an office application file like Excel,Word, PPT, etc.
Quite a few examples can be found at http://www.excelfox.com/forum/f10/
Regards,
Sam Mathai Chacko
On Tue, Apr 3, 2012 at 1:23 AM, Maries
Hi Haseeb, Great Solution...
On Mon, Apr 2, 2012 at 1:54 AM, pawel lupinski lupins...@yahoo.com wrote:
Hi Again,
Thanks again, it's all working, I have a lot to learn what is great,
you've shown me the magic.
thanks
Pawel
--
*From:* pawel lupinski
Thanks SAM. Let me check it...
On Tue, Apr 3, 2012 at 12:16 AM, Sam Mathai Chacko samde...@gmail.comwrote:
The Custom UI Editor Tool is used to modify the XML tag of the custom UI
xml files on an office application file like Excel,Word, PPT, etc.
Quite a few examples can be found at
Hi,
Try below formula for TOI values.
=TEXT(A1,h:mm AM/PM)
Regards,
MARIES.
On Mon, Apr 2, 2012 at 1:40 AM, qcan comeonove...@gmail.com wrote:
Hi,
There is probably a very simple solution here, but I am stumped.
In this link below, you will see a table that has a field called TOI
Hi,
Try, below shown Array formula. (Apply with CSE)
=SUM((--INT(D7:D955)=H13)*--(INT(D7:D955)=H14))
Conditions, H13-Start Date H14-End Date
Regards,
MARIES
On Mon, Apr 2, 2012 at 11:47 AM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote:
Dear Shrini**
Plz find out solve attach file.
Hello Shrini,
=COUNTIF(D:D,=StartDate)-COUNTIF(D:D,=EndDate+1)
Or,
=SUMPRODUCT(COUNTIF(D:D,=IF({1,0},StartDate,EndDate+1))*{1,-1})
this way able to use whole column reference in SUMPRODUCT
Change StartDate EndDate to cell reference
___
HTH, Haseeb
--
FORUM RULES (986+ members
Hi,
In a an adjustent cell try to multiply with 24 round by 3
=ROUND(A1*24,3)
Change A1 to TOI cell.
___
HTH, Haseeb
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
That's works pefectly Haseeb. Thanks !!
On Monday, April 2, 2012 8:17:30 PM UTC-4, Haseeb A wrote:
Hi,
In a an adjustent cell try to multiply with 24 round by 3
=ROUND(A1*24,3)
Change A1 to TOI cell.
___
HTH, Haseeb
--
FORUM RULES (986+ members already BANNED for
FYI,
If you have blank cells or zero in a date column corresponding column has
numbers MONTH function will sum those numbers if the Month in A1 is 1.
because in excel blank zeros consider as Jan (in month case) To avoid
this this need to use a another condition like (Sheet1!A2:A200) or use
Hello Maries
Thanks for the express fast reply :-)
This works beautifully for me and exactly as I had hoped for. Thanks a
lot. Appreciate it.
Thanks
Ashish Pradhan
On 03-04-2012 02:11, Maries wrote:
Hi,
PFA.
Regards,
MARIES.
On Mon, Apr 2, 2012 at 9:27 PM, Ashish Pradhan
Dear Ashok,
You can also use..
*=SUM(IF(MONTH(A2:A7)=D3,B2:B7,))* with CSE(Ctrl+shift+enter)
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
On Mon, Apr 2, 2012 at 1:25 PM, ASHOK PHALKE
40 matches
Mail list logo