Re: $$Excel-Macros$$ please help me GRK

2013-03-02 Thread Aindril De
Dear GRKNAIDU, Please use this formula in the Bonus Qty column and copy down: =IF(MOD(J4,100)=0,(J4/100)*20,ROUNDDOWN(J4/100,0)*20) Regards, Aindril On Sat, Mar 2, 2013 at 5:33 PM, GRKRISHNA NAIDU grnaidu1...@gmail.comwrote: Dear all Will you please help to get the formula for an

Re: $$Excel-Macros$$ Re: Compare two text columns by last name

2013-03-02 Thread Maries
Hi, Try it, =TRIM(RIGHT(SUBSTITUTE(A1, ,REPT( ,100)),100))=TRIM(RIGHT(SUBSTITUTE(B1, ,REPT( ,100)),100)) On Sat, Mar 2, 2013 at 11:46 AM, satyas manav...@gmail.com wrote: Hi Nitin, I found an error when I applied it on my database where there is no space between last name and first name.

$$Excel-Macros$$ How to do an automation for copy paste, added new row? (macro)

2013-03-02 Thread artforart artforart
Hello I have attached file http://www.sendspace.com/file/wjh0oe I want to automated a some step (tab table Z) Thus, for example, that in X 2012: 1) I want to copy D16:E16 2) added a new one blank below before the paste D17:E17 3) converted the 2011 to 2012 in cells D17: E17 (ctr+h function