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.com To: 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 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 -- ---------------------------------------------------------------------------------- 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 -- ---------------------------------------------------------------------------------- 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
How to count only unique values(2).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
