Re: $$Excel-Macros$$ help on if formula

2015-05-20 Thread Abhishek Jain
=IF(C50,0,IF(C5380,C5-B5,IF(AND(D50,D5=380),C5,NA))) Drag down... On Wed, May 20, 2015 at 11:22 AM, ankit sharma excel2...@gmail.com wrote: Dear Experts i want a formula that fulfill my both conditions pls solve this. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

RE: $$Excel-Macros$$ Re: Help Required

2015-05-20 Thread Neeraj
Thanks sir its working and I want this From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mandeep Baluja Sent: Wednesday, May 20, 2015 3:25 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Help Required Want this ? Regards,

Re: $$Excel-Macros$$ Help Required

2015-05-20 Thread Prashant Pednekar
pls check On Wed, May 20, 2015 at 2:58 PM, Neeraj neerajchauhan...@gmail.com wrote: Dear Experts, Kindly find the sheet and do the needful formula -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this

$$Excel-Macros$$ Help Required

2015-05-20 Thread Neeraj
Dear Experts, Kindly find the sheet and do the needful formula -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread

$$Excel-Macros$$ Re: Help Required

2015-05-20 Thread Mandeep Baluja
Want this ? Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/VBAEXCELSQL?ref=hl https://www.linkedin.com/profile/view?id=312532939 On Wednesday, May 20, 2015 at 2:59:09 PM UTC+5:30, neeraj chauhan wrote: Dear Experts, Kindly find the sheet and do the needful formula

Re: $$Excel-Macros$$ Query on Extract word

2015-05-20 Thread Prashant Pednekar
This will work =IFERROR(IFERROR(MID(A2,FIND(MOC,A2,8),7),UPPER(MID(A2,FIND(moc,A2,7),8))),UPPER(MID(A2,FIND(Moc,A2,7),8))) However may of the cases it is written like MOC 9 or MOC - 08 hence some garbage is appearing. you can remove by text to coloumn command. Prashant On Wed, May 20, 2015

RE: $$Excel-Macros$$ Query on Extract word

2015-05-20 Thread Pankaj Sharma
Dear Kalyan, It’s Done!!! PFA =IFERROR(TRIM(CONCATENATE(MOC ,MID(SUBSTITUTE(SUBSTITUTE(A1351,-,), ,),(FIND(MOC,UPPER(SUBSTITUTE(SUBSTITUTE(A1351,-,), ,)))+3),2+(IF(AND((CODE(RIGHT(MID(SUBSTITUTE(SUBSTITUTE(A1351,-,), ,),(FIND(MOC,UPPER(SUBSTITUTE(SUBSTITUTE(A1351,-,),

$$Excel-Macros$$ VBA code for force selection of dropdown

2015-05-20 Thread mayur
Hi Experts, I am looking for vba code for force selection of drop down value if specific column's cell value changes. Also, force user to enter comment in next cell reason for change(minimum 6 and maximum 150 characters allowed. Any help would be appreciated! Thanks, Mayur -- Are you

$$Excel-Macros$$ Re: OpenSchema fails when connecting to a persisted recordset

2015-05-20 Thread Dominic Marshall
Hi, Just an update on this. I thought I would try this in Access so added the following code to test this: Set conn = New ADODB.Connection conn.Provider = MSDataShape conn.Open Data Source=Test Set rs = New ADODB.Recordset rs.Open shape, conn, adOpenStatic, adCmdText

Re: $$Excel-Macros$$ VBA code for force selection of dropdown

2015-05-20 Thread Rahul Bhardwaj
Hi All, Any one can suggest me good coaching institute for excel coaching in Delhi. Regards Rahul On Thu, May 21, 2015 at 2:48 AM, mayur zinknax.zin...@gmail.com wrote: Hi Experts, I am looking for vba code for force selection of drop down value if specific column's cell value changes.

$$Excel-Macros$$ Looking for job

2015-05-20 Thread priti verma
Hi There, Is there any job for vba developer. Thanks Priti -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread