Re: $$Excel-Macros$$ Query on formula

2016-09-16 Thread Kal xcel
Wow.Ashish, After a long time You are still in this group.Helping peopleGr8 yaar How are you?? Where are you now?? Thanks a lot brother...Formula working perfectly On Fri, Sep 16, 2016 at 9:57 PM, Ashish Koul wrote: >

Re: $$Excel-Macros$$ Query on formula

2016-09-16 Thread Learner Excel
Welcome back Ashish!. -- On Fri, Sep 16, 2016 at 9:57 PM, Ashish Koul wrote: > =IF(COUNTIFS($A:$A,$G9,$B:$B,$F9,$C:$C,H$4)=1,"Y","N") > > On Fri, Sep 16, 2016 at 9:47 PM, Kal xcel wrote: > >> Dear Experts, >> >> Please help me to solve the attached

Re: $$Excel-Macros$$ Query on formula

2016-09-16 Thread Ashish Koul
=IF(COUNTIFS($A:$A,$G9,$B:$B,$F9,$C:$C,H$4)=1,"Y","N") On Fri, Sep 16, 2016 at 9:47 PM, Kal xcel wrote: > Dear Experts, > > Please help me to solve the attached query. > > -- > *Kalyan Chattopadhyay* > > > *Executive Corporate MIS* > > *Joy Cosmetics* > > -- > Are you

$$Excel-Macros$$ Query on formula

2016-09-16 Thread Kal xcel
Dear Experts, Please help me to solve the attached query. -- *Kalyan Chattopadhyay* *Executive Corporate MIS* *Joy Cosmetics* -- 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 @

$$Excel-Macros$$ Query - Date Formula

2010-07-10 Thread Nikhil Shah
Dear All, Pl help out my query.. *Starting Dt.01/04/1998 ( Format dd/mm/ ) Ending Dt. 31/03/2003 ( Format dd/mm/ )* Loan Dt ( Format should dd/mm/ ) *[ 1 ]* Loan Dt should be between Starting Dt. And Ending Dt...What is formula ? *[ 2 ]..*... If Loan Dt is below

Re: $$Excel-Macros$$ Query - Date Formula

2010-07-10 Thread Vinod N
Hi, Please use Data Validation Select the Date option from Allow dropdown and mention the start and end date in that. If you are not satisfied with the above please send a sample data and the group members will reply.. Thanks Vinod N On Sat, Jul 10, 2010 at 2:59 PM, Nikhil Shah