can somebody please transfer it to 2003 version? I don't have 2007 in my company.
On Jan 6, 9:40 am, Dave Bonallack <davebonall...@hotmail.com> wrote: > Hi Kalyan, > The attached works, with the following limitations: > That the data in Col A is always the same (as in your sample data) > That any given BP Name is not repeated in more than 1 Depot (as in your > sample data) > If either of the above limitations are unacceptable, then it's back to the > drawing board. > Regards - Dave. > > Date: Thu, 6 Jan 2011 18:40:43 +0530 > Subject: Re: $$Excel-Macros$$ How to count distinct values on the base of > multiple criteria > From: kalx...@gmail.comto:excel-macros@googlegroups.com > CC: jainayus...@gmail.com; schreiner_p...@att.net > > exactly Ayush, I have already tried Paul's solution but I didn't get desired > result. > > I am attaching the file again with expected result > > Please help > > Thanks in advance > > Kalyan > > On Thu, Jan 6, 2011 at 6:13 PM, Ayush <jainayus...@gmail.com> wrote: > > Right Paul, but your formula is counting duplicate values also.This user need > to count only distinct values. correct ? > > Best Regards, > Ayush Jain > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links > :http://twitter.com/exceldailytip > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email toexcel-mac...@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below > linkhttp://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;... > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links > :http://twitter.com/exceldailytip > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > To post to this group, send email toexcel-mac...@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below > linkhttp://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;... > > How to count only unique values(2).xlsx > 15KViewDownload -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
