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

2012-09-05 Thread Muralidhar E
-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 ** ** Dear all, Find the attached file, I want i column E if column D is more than zero

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

2012-09-04 Thread Amresh Maurya
Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* Muralidhar E emuralidha...@gmail.com *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

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

2012-09-04 Thread Amresh Maurya
, 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 it is remarks

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

2012-09-04 Thread Rajan_Verma
: 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 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 emuralidha...@gmail.comwrote: Dear all, Good morning to every body Iam using Office 2010, I need in result column(F) how many times

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 naukrikuld...@gmail.comwrote: Hi Muralidhar, Try this. =IF(D2=E2,COUNTIF($B$2:$B$10,B2),IF(COUNT($E$2:$E$10),,0)) Regards, Kuldeep Singh On

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 emuralidha...@gmail.comwrote: Hi, thanks, But the result is coming wrong, for

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 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
@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 PO under process. Actually i