excel group by count distinct



formula :-

in C2

 =IF(SUMPRODUCT(($A$1:$A3=A3)*($B$1:$B3=B3))>1,0,1)
excel 2007 count unique values multiple criteria 

Comments

  1. AnonymousMay 30, 2014 at 11:21 AM

    Greetings! I've been following your site for some
    time now and finally got the bravery to go ahead
    and give you a shout out from Huffman Tx! Just wanted
    to say keep up the fantastic work!

    Look at my homepage :: Dr Dre Beats

    ReplyDelete
  2. AnonymousJuly 2, 2014 at 4:55 PM

    I just could not leave your website prior to suggesting that I actually loved the standard information an individual
    provide in your visitors? Is gonna be back regularly to check up on new posts

    my weblog: Burberry Silk Scarf

    ReplyDelete
  3. AnonymousJuly 15, 2014 at 12:58 AM

    I really like it when folks come together and share ideas.
    Great website, keep it up!

    Feel free to surf to my web-site - Cheap Beats By Dre;
    Newsvine.com,

    ReplyDelete
  4. AnonymousJuly 17, 2014 at 11:55 PM

    I am sure this paragraph has touched all the internet people, its really really fastidious paragraph on building up new web
    site.

    Feel free to surf to my blog post Beats By Dre Pro

    ReplyDelete
  5. AnonymousAugust 3, 2014 at 3:26 PM

    I am extremely impressed with your writing skills and also with the layout on your blog.
    Is this a paid theme or did you modify it yourself?
    Anyway keep up the excellent quality writing, it is rare to
    see a nice blog like this one today.

    Here is my site :: Burberry Silk Scarf Outlet [cheapsilkscarf.blogspot.com]

    ReplyDelete
  6. AnonymousAugust 5, 2014 at 6:09 AM

    Hello! I've been reading your blog for a while now and finally got the
    courage to go ahead and give you a shout out from Lubbock Tx!
    Just wanted to tell you keep up the fantastic work!


    Here is my site Louis Vuitton Silk Scarf Replica

    ReplyDelete

Post a Comment

If you Satisfied , Please Leave a comment

Popular posts from this blog

Call PHP Function In JavaScript Using Ajax

how to call php function from javascript function 1. create Folder on WWW Or htdocs (on your computer) 2. create index.php page on your folder and paste this code index.php <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>  <script> function addsearchproduct(x){   // this is JavaScript  function    $.ajax({   type: 'POST',   url: "function.php?f=phpFunction&p="+x,          // call php function , phpFunction=function Name , x= parameter     data: {},   success: function(data1){         alert(data1);   } });             } </script> <input type="button" value="call Php Function" onclick="...
Read more

List of Post Category Wise in wordpress

for example show this type Category 1   post1    post 2    post3 category 2    post 1    post 2 Category 3   post1    post 2    post3  code : <?php // get all the categories from the database    $cats  =  get_categories (); // loop through the categries   foreach ( $cats  as  $cat ) {   // setup the cateogory ID    $cat_id =  $cat -> term_id ;   // Make a header for the cateogry    echo  "<h2>" . $cat -> name . "</h2>" ;   // create a custom wordpress query   query_posts ( "cat=$cat_id&post_per_page=100" );    // start the wordpre...
Read more