-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
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
, 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
: 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
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
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
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
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
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
@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
10 matches
Mail list logo