Wednesday, October 30, 2013

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 


6 comments:

  1. 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. 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. 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. 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. 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. 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

If you Satisfied , Please Leave a comment