Re: $$Excel-Macros$$ Serial no

2012-10-31 Thread Aamir Shahzad
you can also use =IF(MONTH($B$2)=MONTH(A5),COUNT($D$3:D4)+1,"") Aamir Shahzad On Wed, Oct 31, 2012 at 5:18 PM, Rohan Young wrote: > hi Prashant, > > PFA > > regds > > On Wed, Oct 31, 2012 at 5:35 PM, Prashant Pawle > wrote: > >> Dear Experts >> >> Please help to arrive serial number with if c

Re: $$Excel-Macros$$ Serial no

2012-10-31 Thread Rohan Young
hi Prashant, PFA regds On Wed, Oct 31, 2012 at 5:35 PM, Prashant Pawle wrote: > Dear Experts > > Please help to arrive serial number with if condition > > Regards, > > Prashant > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ me

Re: $$Excel-Macros$$ Serial no

2012-10-31 Thread NOORAIN ANSARI
Dear Prashant, Please try it. =IF($B$2="&$B$2),"") and See attached sheet for more reference. On Wed, Oct 31, 2012 at 5:35 PM, Prashant Pawle wrote: > Dear Experts > > Please help to arrive serial number with if condition > > Regards, > > Prashant > > -- > Join official facebook page of this f

Re: $$Excel-Macros$$ Serial no

2012-10-31 Thread Satendra kumar
Hi, Try this...=COUNTIF($A$4:A4,A4) On Wed, Oct 31, 2012 at 5:35 PM, Prashant Pawle wrote: > Dear Experts > > Please help to arrive serial number with if condition > > Regards, > > Prashant > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RUL

$$Excel-Macros$$ Serial no

2012-10-31 Thread Prashant Pawle
Dear Experts Please help to arrive serial number with if condition Regards, Prashant -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like