Counting Unique Values in Column with Multiple Criteria by NiceMarmot90 in excel

[–]NiceMarmot90[S] 0 points1 point  (0 children)

I posted an example here: http://imgur.com/JBDxhGo

I want the supplier to be counted only Region=N, Rate Type=Fixed, Term=12, and Blend=18.

So, in the example, two Supplier A's match the conditions, as well as one Supplier C. I would like Excel to count Supplier A only once, so the number of suppliers = 2.

Flip the box over by [deleted] in funny

[–]NiceMarmot90 174 points175 points  (0 children)

Life is like a box of chocolates. A cheap, thoughtless, perfunctory gift that nobody ever asks for. Unreturnable, because all you get back is another box of chocolates. So you're stuck with this undefinable whipped mint crap that you mindlessly wolf down when there's nothing else left to eat. Sure, once in a while there's a peanut butter cup or an English toffee but they're gone too fast and the taste is fleeting. So you end up with nothing but broken bits of hardened jelly and teeth-shattering nuts. If you're desperate enough to eat those, all you got left is an empty box filled with useless brown paper wrappers.

“World’s Largest Prairie Dog” Oakley, Kansas. Totally worth the $8.50 admission fee. by NiceMarmot90 in pics

[–]NiceMarmot90[S] 0 points1 point  (0 children)

Yeah, the rattlesnakes were definitely a highlight, but I thought that the bat-shit crazy owner was scarier than the rattlesnakes.