http://groups.google.com/group/excel-macros/subscribe
click on unsubscribe
On Tue, Nov 29, 2011 at 1:06 PM, smitha.kumari
smitha.kum...@speridian.comwrote:
Sorry, I didn’t find the way to unsubscribe. Please help
** **
Regards
Smitha
*From:* excel-macros@googlegroups.com
Thanks Ashish
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Tuesday, November 29, 2011 1:51 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ stop receiving mail in this mail id
Hi,
PFA the expense sheet and suggest a formula to solve the problem as
mentioned in the attachment.
Regards
Smitha
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
An easy solution would be Sumif Function. See attached.
Regards,
Manish
On Tue, Nov 29, 2011 at 2:53 PM, smitha.kumari
smitha.kum...@speridian.comwrote:
Hi,
** **
PFA the expense sheet and suggest a formula to solve the problem as
mentioned in the attachment.
** **
Thanks Manish
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Manish Pandey
Sent: Tuesday, November 29, 2011 2:55 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Formula to sum a range of cells satisfying a
particular criteria
An
Hi samitha,
Pls find attached file espenses.
On Tue, Nov 29, 2011 at 3:03 PM, smitha smitha.kum...@speridian.com wrote:
Thanks Manish
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Manish Pandey
*Sent:* Tuesday, November 29, 2011
Hello Mr Sam,
Thank you very much of your help.
Regards
Son
2011/11/28 Sam Mathai Chacko samde...@gmail.com
Great, so no modifications required for Excel 2010
The code below works for both 2003 and 2010
Sub Consolidator()
Dim rngStart As Range
Dim varArray As Range
I want to find threee highest amt against 1 po no , while po no enter
dublicate
--
Thanks Regards
Aivran kumar
,E-mail:- aivran...@gmail.com aivran...@gmial.com*
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Dear All HI
Please Find attach file for my quary.
it is for stck matter please halp and provide the proper formula so i can
calculate the stock
for more details please refer the stock file.
--
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles.
Dear Aivi,
Please use this and see attached sheet.
=LARGE(IF($A$2:$A$33=$F$3,$B$2:$B$33,),1)
Press ctrl+shift+Enter
=SUMPRODUCT(LARGE(($A$2:$A$33=$F$3)*($B$2:$B$33),1))
Press ctrl+shift+enter
-
Thanks regards,
Noorain Ansari
Hi Aivi,
Thanks.
May I ask you, why + symbol is inserted before sumif ?
Regards
Smitha
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aivi
Sent: Tuesday, November 29, 2011 3:24 PM
To: excel-macros@googlegroups.com
Subject: Re:
Hi,
Is there a quick way to convert row to column or vice versa
Regards
Smitha
--
FORUM RULES (934+ 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
A Lot Thanks Norain.
On Tue, Nov 29, 2011 at 3:54 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Aivi,
Please use this and see attached sheet.
=LARGE(IF($A$2:$A$33=$F$3,$B$2:$B$33,),1)
Press ctrl+shift+Enter
=SUMPRODUCT(LARGE(($A$2:$A$33=$F$3)*($B$2:$B$33),1))
Press
+ symbol is inserted for useing formulas whether u can use = sing
On Tue, Nov 29, 2011 at 4:04 PM, smitha.kumari
smitha.kum...@speridian.comwrote:
Hi Aivi,
** **
Thanks.
** **
May I ask you, why + symbol is inserted before sumif ?
** **
Regards
Smitha
** **
Hi Samitha,
Please find attached sheet with *DSUM SUMPRODUCT.*
-
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Tue, Nov 29, 2011 at 2:53 PM, smitha.kumari
You can use Transpose function..
On Tue, Nov 29, 2011 at 4:05 PM, smitha.kumari
smitha.kum...@speridian.comwrote:
Hi,
** **
Is there a quick way to convert row to column or vice versa
** **
Regards
Smitha
** **
--
FORUM RULES (934+ members already BANNED for
Hi Smitha,
This is array Function
Press ctrl+shift+enter after F2
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Tue, Nov 29, 2011 at 5:52 PM,
thanks
Regards
Smitha/ Senior Finance Executive
Speridian%20Logo
World Class Solutions to Power Global Businesses
Office: 0471-2527525/2700526
smitha.kum...@speridian.com
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent:
Dear Ankit,
I not found attachment can you send me the same.
Thanks In Advance,
Nehal A.Sejpal
On Tue, 29 Nov 2011 17:31:43 +0530 wrote
2011/11/28 vijayajith VA
Thanks ankit.
On Mon, Nov 28, 2011 at 12:06 PM, Ankit Agrawal wrote:
Hello All,
In our daily life we calculate so many
Save the file to your desktop and right mouse click and select open with.
This should give you an option to open it with xlm converter. Try that first to
see if it converts the file. If this opens the file and converts it for you,
you will need to select the open with and select choose program.
Neha, I have already attached the file. Please check my previous post.
Sam
On Tue, Nov 29, 2011 at 5:38 PM, nehal sejpal nehal_c...@rediffmail.comwrote:
Dear Ankit,
I not found attachment can you send me the same.
Thanks In Advance,
Nehal A.Sejpal
On Tue, 29 Nov 2011 17:31:43 +0530
Go to ToolsMacroSecurityProgrammatic AccessNever Warn
Sam
On Tue, Nov 29, 2011 at 8:28 AM, maulik desai mauliksde...@gmail.comwrote:
Thanks you so much deepak for your great support lastly i just want to ask
you 1 thing that when ever i clicked on
Macro for mail send microsoft gives me pop
Here's a very good Gantt chart template from Chandoo
http://chandoo.org/wp/2009/06/16/gantt-charts-project-management/
Regards,
Sam Mathai Chacko
On Tue, Nov 29, 2011 at 10:17 AM, Brajesh Kumar Porwal
brajeshkumarpor...@gmail.com wrote:
Hi,
Gantt charts can be used to show current
Abhidha, this doesn't look like an Excel problem/question/query.
Ayush, probably something you want to add on the rules and regulations
section?
Regards,
Sam Mathai Chacko
On Tue, Nov 29, 2011 at 1:05 AM, Abhidha Dixit abhidha.di...@gmail.comwrote:
Hi Friends
Please help me in sloving
Dear Group Members,
This requirement is for the team that I lead in the KPO research and
analytics vertical of WNS Global Services, Gurgaon.
We are looking for two Excel Specialists, well versed in Excel formula
and it's application in various situations (should be well versed with
text
Same here Mr.Ankit. If you can please resend the worksheet.
Thanks Regards,
Sujit Mazumdar
Sent on my BlackBerry® from Vodafone
-Original Message-
From: nehal sejpal nehal_c...@rediffmail.com
Sender: excel-macros@googlegroups.com
Date: 29 Nov 2011 12:08:55
To:
Please make sure that you are sharing only free material in the forum and
not the paid one.
As per rules, you will be banned on violation.
Thanks !
Keep Posting !
Regards
Ayush Jain
On Sat, Nov 26, 2011 at 1:35 AM, kJo contactkkjo...@gmail.com wrote:
What address or contact number pls?
Any
i have a simple formula like =(a2+b2)/2 it returns zero for empty
cells yet I want it to leave empty cells blank please help
--
*If u wanna dream dream BIG
*You`ve got to do your own growing, no matter how tall your grandfather was
Kayoub K
0772656158 / 0703516660
PMTCT Data Manager
Mujhu
=if((a2+b2)/2=0,,(a2+b2)/2)
I hope it helps.
Thanks.
On Tue, Nov 29, 2011 at 10:57 PM, Ayoub Kakande akaka...@gmail.com wrote:
i have a simple formula like =(a2+b2)/2 it returns zero for empty
cells yet I want it to leave empty cells blank please help
--
*If u wanna dream dream BIG
For cases where |B1| = A1 or vice versa, use *
=IF(COUNTA(A1:B1),(A1+B1)/2,)*
Regards,
Sam Mathai Chacko
On Tue, Nov 29, 2011 at 11:04 PM, Ayush Jain jainayus...@gmail.com wrote:
=if((a2+b2)/2=0,,(a2+b2)/2)
I hope it helps.
Thanks.
On Tue, Nov 29, 2011 at 10:57 PM, Ayoub Kakande
Thx Sam, I will try this tomorrow and if it works in office 2K3, it will solve
an year old problem for me.
Dear developers,
Just to extend this conversation and make it more wholesome. I am using MS
office 2011 on a mac machine. How do I link excel to mail app on Mac instead of
outlook.
Dear Developers,
I am looking for an excel macro to translate a sentence in a cell from one
language to another and paste the result in another cell next to it.
Thx in advance.
Rgds,
Roopesh Kapur
E:roopesh.ka...@gmail.com
--
FORUM RULES (934+ members already BANNED for violation)
1) Use
You could possibly use the Google Translation API, but I am not sure if
they have one for VB or VBA. If they do, probably have to pay some money
for that. But search for the text Google Translation API for VB/VBA, and
you might get something. If you reach a dead end, post back. Maybe we could
Another feature that Excel 2007-10 provides in terms of Translation can be
found in the Review tab. If you have a cell selected, and use this
translation feature, it will most likely translate it for you
automatically. The manual part is that you will have to click on the insert
button or copy
Hi,
i want to copy paste data from Excel to specific location in microsoft word
using Excel macro.
i am able to copy paste it at the beginning of word document but not on
specific location.
below is my requirement.
1. i need to find specific word in microsoft word doc --- Done
2. just 1 place
Excel Teachers,
I need to look at a cell and if it contains specific characters (for
example the three characters “410”), return a specific value and if not
return a blank. The string can be quite long or short and the “410” may or
may not be in it and its location when it is in it could be at
Don Guillett
SalesAid Software
dguille...@gmail.com
From: John A. Smith
Sent: Tuesday, November 29, 2011 3:08 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Returning a Value Based on a String Containing
Specific Characters
Excel Teachers,
I need to look at a cell and if it
You need to explain a bit more with examples
Don Guillett
SalesAid Software
dguille...@gmail.com
From: manhar prajapati
Sent: Tuesday, November 29, 2011 4:14 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help for stock file
Dear All HI
Please Find attach file for my quary.
Thank you Don, I appreciate the help.
John
On Tue, Nov 29, 2011 at 5:04 PM, dguillett1 dguille...@gmail.com wrote:
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* John A. Smith johnasmit...@gmail.com
*Sent:* Tuesday, November 29, 2011 3:08 PM
*To:*
Hi,
Thanks these help.
But need some additional input. these work only PST or OST file...can u
help with any file pattern..like .DOC, XLS,.XL.PPT ,etc
Regards
Chethan Kumar BN
On Wed, Nov 30, 2011 at 4:16 AM, dguillett1 dguille...@gmail.com wrote:
Here is a file that should help
Don
I didn’t create the file but the macro appears to get ALL file extensions.
Denon_AVR786_1.pdf
Denon_DVD556_DFU.pdf
desktop.ini
Double click symbol in Symbols to get chart.gif
DSC_0001 [800x600].JPG
Don Guillett
SalesAid Software
dguille...@gmail.com
From:
thanks.
On 29 November 2011 11:05, Ankit Agrawal ankit.agrawal...@gmail.com wrote:
Hi Aamir,
1. Click the *Microsoft Office Button* [image: Button image], click *Excel
Options*, and then click *Add-Ins*.
2. View the add-ins and application extensions that are categorized as
Dear Sir
I require a formula which can deducted raw material and packing material
when i enter the procution.
Example:
If i enter production of protozyme II of 5000 kg and use blank granule
4950kg and seaweed 50ltr so when i enter Protozyme II 5000kg it is deducted
form raw material and and
Dear Excel Gurus,
Does any one have links for sites/blogs which have challenging puzzles/ quiz
related to excel 2007... I searched google, all the existing sites have simple
excel puzzles..
Appreciate if you can provide the link at your earliest..
Thanks in advance.
Krishnan
Sent on my
Thanks Sam !!
On Tue, Nov 29, 2011 at 7:46 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Abhidha, this doesn't look like an Excel problem/question/query.
Ayush, probably something you want to add on the rules and regulations
section?
Regards,
Sam Mathai Chacko
On Tue, Nov 29, 2011 at
Dear Lucky,
Please paste below formula in B2 Cell.
=IF(AND(A2=$F$2,A2=$G$2),0-3 Month,IF(AND(A2=$F$3,A2=$G$3),3-6
Month,IF(AND(A2=$F$4,A2=$G$4),6-9
Month,IF(AND(A2=$F$5,A2=$G$5),9-12
Month,IF(AND(A2=$F$6,A2=$G$6),12 Month,Prospect)
On Wed, Nov 30, 2011 at 12:09 PM, lucky singh
Hi Singh,
Would you explain the logic for the file? If 1 value is bigger than another
1, you would like the cell to return something, am i right??
Darwin
2011/11/30 lucky singh lucky60...@gmail.com
Hello Team,
Require your help for If nesting formula please see the attachment.
Regards,
Thanx to all my team member and Noorain.
On Wed, Nov 30, 2011 at 12:24 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Lucky,
Please paste below formula in B2 Cell.
=IF(AND(A2=$F$2,A2=$G$2),0-3 Month,IF(AND(A2=$F$3,A2=$G$3),3-6
Month,IF(AND(A2=$F$4,A2=$G$4),6-9
48 matches
Mail list logo
