=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?
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,
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
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
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
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
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,-,),
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
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
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.
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
11 matches
Mail list logo