Re: $$Excel-Macros$$ Fill the formula in yellow using "IF" function!!!

2016-07-19 Thread Murali Nagarajan
Dear Sachin, PFA On Tue, Jul 19, 2016 at 4:59 PM, सचिन शर्मा wrote: > Thanks Paul, > > For answer and your observation, > > Now it's working correctly. > > Regards. > > *Sachin* > > # +91 97 16 437516 > # +91 72 91 932360 > > On Tuesday, July 19, 2016 at 4:51:00 PM UTC+5:30, Paul Schreiner wro

$$Excel-Macros$$ Re: Extract Text that begins with L

2016-07-19 Thread सचिन शर्मा
Please check Cash paid to L986529 - RAMESH KUMAR K EMP ID L986529 - =MID(B2,FIND("L",B2),7) - *" 7 " = Lenth of EMP ID * On Wednesday, July 20, 2016 at 10:48:09 AM UTC+5:30, Sundarvelan wrote: > > Dear Experts, > > Please help me to extract EMP ID. > > I have the below sente

$$Excel-Macros$$ Extract Text that begins with L

2016-07-19 Thread Sundarvelan N
Dear Experts, Please help me to extract EMP ID. I have the below sentence in D2 Cell, and i need to extract the EMP ID which starts with L D2 = Cash paid to L986529 - RAMESH KUMAR K towards Accomdation Charges on 09.05.2016 to 11.05.2016 amount:4100-- for Corporate Approved by Mr.Arvind Thanks

$$Excel-Macros$$ Updated Hot-list of SAP BPC, Hana, Security,BI, BW, BOBJ & Oracle APPS

2016-07-19 Thread Recruiter Astuteone
Hello Partner, Hope you are doing well… Please find the updated Hotlist of available consultants with AstuteOne Corp. They are technically strong and can attend face to face for local positions. If you have any suitable requirements for the below skills, Feel free to contact me at sin...@astute

Re: $$Excel-Macros$$ Fill the formula in yellow using "IF" function!!!

2016-07-19 Thread सचिन शर्मा
Thanks Paul, For answer and your observation, Now it's working correctly. Regards. *Sachin* # +91 97 16 437516 # +91 72 91 932360 On Tuesday, July 19, 2016 at 4:51:00 PM UTC+5:30, Paul Schreiner wrote: > > I think your logic MAY be flawed. > > In your example, TL2 has: > 95 94 78 > > Data

Re: $$Excel-Macros$$ Fill the formula in yellow using "IF" function!!!

2016-07-19 Thread Paul Schreiner
I think your logic MAY be flawed. In your example, TL2 has:95 94 78 Data1 (95) matches Bucket B.Data2 (94) matches Bucket A.Data3 (78) matches Bucket B. so 0 should be returned? Based on your criteria, none of the Team Leaders would receive "Incentive". Is that correct?---If you changed your crite

Re: $$Excel-Macros$$ Fill the formula in yellow using "IF" function!!!

2016-07-19 Thread Sachin Panchal
Dear sachin try this i hope your problem will be solve with my rule On Tue, Jul 19, 2016 at 12:42 PM, सचिन शर्मा wrote: > Dear All, > > > > PFA, > > > > Calculate the incentive according 3 data base ( *DATA 1, DATA 2, DATA 3*) > and 3 different grads ( *A, B, C* ) > > > > Criteria and achieveme

$$Excel-Macros$$ Fill the formula in yellow using "IF" function!!!

2016-07-19 Thread सचिन शर्मा
Dear All, PFA, Calculate the incentive according 3 data base ( *DATA 1, DATA 2, DATA 3*) and 3 different grads ( *A, B, C* ) Criteria and achievement both in attached sheet. Regards. *Sachin* # +91 97 16 437516 # +91 72 91 932360 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) i

$$Excel-Macros$$ Re: Help on Vlookup

2016-07-19 Thread सचिन शर्मा
Hi PFA, Regards, Sachin On Friday, June 17, 2016 at 12:52:48 PM UTC+5:30, vikas khen wrote: > > Hi all, > > > > Need your help on attached excel sheet as my vlookup formula is not > reflecting the value. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME