Re: $$Excel-Macros$$ Help for If nesting formula

Thanx to all my team member and Noorain. On Wed, Nov 30, 2011 at 12:24 PM, NOORAIN ANSARI wrote: > 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<

Re: $$Excel-Macros$$ Help for If nesting formula

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 > > Hello Team, > > > Require your help for If nesting formula please see the attachment. > > > Regards, > Lucky > >

Re: $$Excel-Macros$$ Help for If nesting formula

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, luc

Re: $$Excel-Macros$$ Fwd:

Thanks Sam !! On Tue, Nov 29, 2011 at 7:46 PM, Sam Mathai Chacko wrote: > 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

$$Excel-Macros$$ Link for complex excel 2007 puzzles

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 Blac

Re: $$Excel-Macros$$ Help for stock file

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 pack

Re: $$Excel-Macros$$ re: conversion of numbers

thanks. On 29 November 2011 11:05, Ankit Agrawal 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 >follows: > - *Ac

Re: $$Excel-Macros$$ Need Help

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: B.N

Re: $$Excel-Macros$$ Need Help

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 wrote: > Here is a file that should help > > Don Guillett > SalesAid

Re: $$Excel-Macros$$ Returning a Value Based on a String Containing Specific Characters

Thank you Don, I appreciate the help. John On Tue, Nov 29, 2011 at 5:04 PM, dguillett1 wrote: > > > 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$

Re: $$Excel-Macros$$ Help for stock file

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.

Re: $$Excel-Macros$$ Returning a Value Based on a String Containing Specific Characters

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

$$Excel-Macros$$ Returning a Value Based on a String Containing Specific Characters

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 th

$$Excel-Macros$$ Excel to Word

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

Re: $$Excel-Macros$$ macro to translate from one languague to another

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 butt

Re: $$Excel-Macros$$ macro to translate from one languague to another

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 help.

$$Excel-Macros$$ macro to translate from one languague to another

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 con

Re: $$Excel-Macros$$ Re: Email Macro required for mail Boday

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. Assumi

Re: $$Excel-Macros$$

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 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 wrote: > >> i have

Re: $$Excel-Macros$$

=if((a2+b2)/2=0,"",(a2+b2)/2) I hope it helps. Thanks. On Tue, Nov 29, 2011 at 10:57 PM, Ayoub Kakande 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 > *You`ve got to d

$$Excel-Macros$$

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 Resea

Re: $$Excel-Macros$$ Excel learning Institute

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 wrote: > What address or contact number pls? > > Any where in Borivli ? > >

Re: Re: $$Excel-Macros$$ Almost all calculator in one sheet

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" Sender: excel-macros@googlegroups.com Date: 29 Nov 2011 12:08:55 To: Reply-To: excel-macros@googlegroups.com Subject

$$Excel-Macros$$ Excel and VBA Developer Required in Gurgaon

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 functions

Re: $$Excel-Macros$$ Fwd:

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 wrote: > > Hi Friends > > Please help me in sloving these problems > > Rega

Re: $$Excel-Macros$$ Re: Grant chart.......

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 sch

Re: $$Excel-Macros$$ Re: Email Macro required for mail Boday

Go to Tools>Macro>Security>Programmatic Access>Never Warn Sam On Tue, Nov 29, 2011 at 8:28 AM, maulik desai wrote: > 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 up for stating

Re: Re: $$Excel-Macros$$ Almost all calculator in one sheet

Neha, I have already attached the file. Please check my previous post. Sam On Tue, Nov 29, 2011 at 5:38 PM, nehal sejpal wrote: > > 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

Re: $$Excel-Macros$$ how to open a 2007 excel file in previous version of excel

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 progra

Re: Re: $$Excel-Macros$$ Almost all calculator in one sheet

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

RE: $$Excel-Macros$$ #value in formula

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: Tuesda

Re: $$Excel-Macros$$ #value in formula

Hi Smitha, This is array Function Press ctrl+shift+enter after F2 -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Tue, Nov 29, 2011 at 5:52 PM, smith

Re: $$Excel-Macros$$ convert row to column or vice versa

You can use Transpose function.. On Tue, Nov 29, 2011 at 4:05 PM, smitha.kumari wrote: > Hi, > > ** ** > > Is there a quick way to convert row to column or vice versa > > ** ** > > Regards > > Smitha > > ** ** > > -- > FORUM RULES (934+ members already BANNED for violation) > >

Re: $$Excel-Macros$$ Formula to sum a range of cells satisfying a particular criteria

Hi Samitha, Please find attached sheet with *DSUM & SUMPRODUCT.* - Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Tue, Nov 29, 2011 at 2:53 PM, smitha.ku

Re: $$Excel-Macros$$ Formula to sum a range of cells satisfying a particular criteria

+ symbol is inserted for useing formulas whether u can use = sing On Tue, Nov 29, 2011 at 4:04 PM, smitha.kumari wrote: > Hi Aivi, > > ** ** > > Thanks. > > ** ** > > May I ask you, why + symbol is inserted before sumif ? > > ** ** > > Regards > > Smitha > > ** ** > > *From:

Re: $$Excel-Macros$$ PO highest amt

A Lot Thanks Norain. On Tue, Nov 29, 2011 at 3:54 PM, NOORAIN ANSARI wrote: > 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 > > - > T

$$Excel-Macros$$ convert row to column or vice versa

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

RE: $$Excel-Macros$$ Formula to sum a range of cells satisfying a particular criteria

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: $$Excel-Macro

Re: $$Excel-Macros$$ PO highest amt

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 *http://excelmacroworld.blogspot.com/*

$$Excel-Macros$$ Help for stock file

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.

$$Excel-Macros$$ PO highest amt

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 * -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, N

Re: $$Excel-Macros$$ Help me with a macro

Hello Mr Sam, Thank you very much of your help. Regards Son 2011/11/28 Sam Mathai Chacko > 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 > > > Applicatio

Re: $$Excel-Macros$$ Formula to sum a range of cells satisfying a particular criteria

Hi samitha, Pls find attached file espenses. On Tue, Nov 29, 2011 at 3:03 PM, smitha wrote: > 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-m

RE: $$Excel-Macros$$ Formula to sum a range of cells satisfying a particular criteria

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 ea

Re: $$Excel-Macros$$ Formula to sum a range of cells satisfying a particular criteria

An easy solution would be Sumif Function. See attached. Regards, Manish On Tue, Nov 29, 2011 at 2:53 PM, smitha.kumari wrote: > Hi, > > ** ** > > PFA the expense sheet and suggest a formula to solve the problem as > mentioned in the attachment. > > ** ** > > Regards > > Smitha

$$Excel-Macros$$ Formula to sum a range of cells satisfying a particular criteria

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 Pr

RE: $$Excel-Macros$$ stop receiving mail in this mail id

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 http://groups.google.com/group/excel

Re: $$Excel-Macros$$ stop receiving mail in this mail id

http://groups.google.com/group/excel-macros/subscribe click on unsubscribe On Tue, Nov 29, 2011 at 1:06 PM, smitha.kumari wrote: > Sorry, I didn’t find the way to unsubscribe. Please help > > ** ** > > Regards > > Smitha > > *From:* excel-macros@googlegroups.com [mailto: > excel-m