Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-24-2015, 05:05 AM
caeiro01 caeiro01 is offline Count unique values that match 2 or more criteria Windows 7 32bit Count unique values that match 2 or more criteria Office 2010 32bit
Novice
Count unique values that match 2 or more criteria
 
Join Date: Oct 2015
Posts: 1
caeiro01 is on a distinguished road
Question Count unique values that match 2 or more criteria

Hi all,

i need count the number of persons assign to some tasks in one particular day.
Ex. how many persons made the task "a" and "c" on the 24-10-2015?

the answer should be 5



tks
Antonio
Attached Files
File Type: xlsx count unique values with criteria.xlsx (11.6 KB, 11 views)
Reply With Quote
  #2  
Old 10-25-2015, 02:34 AM
xor xor is offline Count unique values that match 2 or more criteria Windows 10 Count unique values that match 2 or more criteria Office 2013
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default Count unique values that match 2 or more criteria

See the attached
Attached Files
File Type: xlsx count_unique_2.xlsx (12.3 KB, 11 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
compare, match and count cell contents between sheets bobsone1 Excel 11 08-07-2014 10:34 PM
Count unique values that match 2 or more criteria Display unique values and count the number of child items vthomeschoolmom Excel 2 07-25-2013 06:17 AM
Count unique values that match 2 or more criteria Vlookup or Index/Match - Multiple Criteria ruci1225 Excel 1 01-15-2012 07:31 AM
If two geographical data match in two sheets, copy unique id/code found in one sheet alliage Excel 1 09-01-2011 05:23 AM
How to count cells containing data and meet certain criteria AdamNT Excel 1 08-11-2006 11:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:10 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft