Re: $$Excel-Macros$$ Help needed to create a function within a macro

2012-10-10 Thread Swapnil Palande
Hi, Here is another solution without inserting exta column "Column D". Don't ask me to explain this formula, because I also don't know how it works. [?] I get this formula from net and just modified it. Following is the link from where I get it. http://www.excelforum.com/excel-formulas-and-funct

Re: $$Excel-Macros$$ Help needed to create a function within a macro

2012-10-10 Thread Swapnil Palande
Hi, Pls find attached excel. Check if it is ok with you. Regards, Swapnil. On Wed, Oct 10, 2012 at 1:41 PM, Henning Deschka wrote: > Hi all, > > thank you all for your help and time that you spend to solve this problem! > I am very happy with the solution that Ashish attached. > > This solut

Re: $$Excel-Macros$$ Help needed to create a function within a macro

2012-10-10 Thread Henning Deschka
Hi all, thank you all for your help and time that you spend to solve this problem! I am very happy with the solution that Ashish attached. This solution works perfect and I am very happy with it - thank you! Unfortunately, I forgot to mention something important yesterday ... I need this fu

Re: $$Excel-Macros$$ Help needed to create a function within a macro

2012-10-09 Thread ashish koul
see the attachment check the cells with "Yellow" color On Tue, Oct 9, 2012 at 8:48 PM, Swapnil Palande wrote: > Hi, > > Insert followibg formula in D1 cell. > > =if(and(or(a1=1,b1=1),c1>23400),3,0) > > Hope this is what u want. > > Regards > > swapnil, > On Oct 9, 2012 6:57 PM, "Henning Deschk

Re: $$Excel-Macros$$ Help needed to create a function within a macro

2012-10-09 Thread Swapnil Palande
Hi, Insert followibg formula in D1 cell. =if(and(or(a1=1,b1=1),c1>23400),3,0) Hope this is what u want. Regards swapnil, On Oct 9, 2012 6:57 PM, "Henning Deschka" wrote: > Hi NG, > > I need to insert a function into cell D1 with an Excel2007 macro that > executes the following: > >

$$Excel-Macros$$ Help needed to create a function within a macro

2012-10-09 Thread Henning Deschka
Hi NG, I need to insert a function into cell D1 with an Excel2007 macro that executes the following: A B C D row 1 12343 row 21 123444 row 31 43322 row 4