Re: $$Excel-Macros$$ Count when po is greater than zero

2012-09-05 Thread Muralidhar E
> * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E > *Sent:* 04 September 2012 11:28 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Count when po is greater than zero > > **

RE: $$Excel-Macros$$ Count when po is greater than zero

2012-09-04 Thread Rajan_Verma
om> Sent: Monday, September 03, 2012 3:33 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Count when po is greater than zero Hi, Thanks for quickly reply, but it is not working, in result columncount of name is not coming, name is appears, Plz, ignore the column E

Re: $$Excel-Macros$$ Count when po is greater than zero

2012-09-03 Thread Amresh Maurya
ft Excel Developer >>> SalesAid Software >>> dguille...@gmail.com >>> >>> *From:* Muralidhar E >>> *Sent:* Monday, September 03, 2012 3:33 AM >>> *To:* excel-macros@googlegroups.com >>> *Subject:* Re: $$Excel-Macros$$ Count when p

Re: $$Excel-Macros$$ Count when po is greater than zero

2012-09-03 Thread Amresh Maurya
and examples. >> >> Don Guillett >> Microsoft Excel Developer >> SalesAid Software >> dguille...@gmail.com >> >> *From:* Muralidhar E >> *Sent:* Monday, September 03, 2012 3:33 AM >> *To:* excel-macros@googlegroups.com >> *Subject:* R

Re: $$Excel-Macros$$ Count when po is greater than zero

2012-09-03 Thread Muralidhar E
s@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Count when po is greater than zero > > Hi, > > Thanks for quickly reply, but it is not working, in result columncount of > name is not coming, name is appears, > > Plz, ignore the column E it is remarks for the status of P

Re: $$Excel-Macros$$ Count when po is greater than zero

2012-09-03 Thread dguillett1
Provide a file and a complete explanation and examples. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Muralidhar E Sent: Monday, September 03, 2012 3:33 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Count when po is greater than zero

Re: $$Excel-Macros$$ Count when po is greater than zero

2012-09-03 Thread Muralidhar E
Hi, Thanks for quickly reply, but it is not working, in result columncount of name is not coming, name is appears, Plz, ignore the column E it is remarks for the status of PO under process. Actually i want the vendor name how many times it is repeat when it has PO, if PO is not confirmed it will

Re: $$Excel-Macros$$ Count when po is greater than zero

2012-09-03 Thread Kuldeep Singh
Hi Murli, Try this one. =IFERROR(INDEX($B$2:$B$10,SMALL(IF($D$2:$D$10>=E2,ROW($E$2:$E$10),""),COUNTIF($B$2:B10,B2))-1),"0") Ctrl + Shift + Enter Regards, Kuldeep Singh On Mon, Sep 3, 2012 at 12:29 PM, Muralidhar E wrote: > Hi, > > thanks, But the result is coming wrong, for blank "p o" vendor

Re: $$Excel-Macros$$ Count when po is greater than zero

2012-09-03 Thread Muralidhar E
Hi, thanks, But the result is coming wrong, for blank "p o" vendor name is taking in calculation. On Mon, Sep 3, 2012 at 11:52 AM, Kuldeep Singh wrote: > > Hi Muralidhar, > > Try this. > > =IF(D2>=E2,COUNTIF($B$2:$B$10,B2),IF(COUNT($E$2:$E$10),"","0")) > > Regards, > Kuldeep Singh > > > On Mon,

Re: $$Excel-Macros$$ Count when po is greater than zero

2012-09-02 Thread Kuldeep Singh
Hi Muralidhar, Try this. =IF(D2>=E2,COUNTIF($B$2:$B$10,B2),IF(COUNT($E$2:$E$10),"","0")) Regards, Kuldeep Singh On Mon, Sep 3, 2012 at 11:15 AM, Muralidhar E wrote: > > Dear all, > > Good morning to every body > > Iam using Office 2010, I need in result column(F) how many times the > vendor na