Hello,
New to the forum, signed up becasue I'm very stuck here...
RE: Count unique values, but with multiple criteria.
Doing my nut in... I just can’t seem to find anything that works. I actually have about 6 criteria to check before I want excel to count!
EG: count unique values in the 3rd column where ‘f’ is in the 1st column and ‘1’ is in the second column.
The answer should be 2.
f 1 aa
f 1 aa
f 1 aa
f 1 bb
f 2 bb
f 2 bb
f 2 cc
f 2 cc
Thanks,
TNM
use COUNTIFS
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi, an attempt.
In range A2:A100 "F", in B2:B100 1 2 3, in C2:C100 aa bb cc
In D2:
to be confirmed with control+shift+enter.
Please Login or Register to view this content.
Regards
Last edited by canapone; 02-01-2012 at 01:26 PM. Reason: NO ; IN THE FORMULA
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Superb, works perfectly!Originally Posted by CANAPONE
Hi, an attempt.
In range A2:A100 "F", in B2:B100 1 2 3, in C2:C100 aa bb cc
In D2:
to be confirmed with control+shift+enter.Please Login or Register to view this content.
Regards
Many thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks