Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-27-2019, 03:10 AM
specky_ specky_ is offline How to count unique names appeared on specific date for daily report? Windows 7 32bit How to count unique names appeared on specific date for daily report? Office 2010
Novice
How to count unique names appeared on specific date for daily report?
 
Join Date: Jan 2019
Posts: 2
specky_ is on a distinguished road
Default How to count unique names appeared on specific date for daily report?

Hello everyone,

Urgent help needed to process some data and I have 2 problems right here. I am required to use formula on the end result table, and not filter function.



Problem 1:

How to show that each day, only a certain number of unique name appears.
Eg: On 3/12/2018, Andrea, Thomas and Nicky appeared, so 3 (as in 3 persons) shows in I6



Problem 2

How to show that on each day, the number of person hit with either 4 flags, 3 flags, 2 flags or 1 flag.
Eg: On 5/12/2018, both Andrea and Nicky hit with 3 flags so 2 (as in 2 person) should appear in M8
Note: A person won't hit same type of Flag on the same date


The set of data and end result table attached.


Any assistance is highly appreciated.


Thank you.
Attached Files
File Type: xlsx Flags.xlsx (11.2 KB, 8 views)
Reply With Quote
  #2  
Old 01-27-2019, 04:40 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to count unique names appeared on specific date for daily report? Windows 7 64bit How to count unique names appeared on specific date for daily report? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,527
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

Hi and welcome
is this some kind of homework?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 01-27-2019, 05:12 AM
specky_ specky_ is offline How to count unique names appeared on specific date for daily report? Windows 7 32bit How to count unique names appeared on specific date for daily report? Office 2010
Novice
How to count unique names appeared on specific date for daily report?
 
Join Date: Jan 2019
Posts: 2
specky_ is on a distinguished road
Default

Quote:
Originally Posted by Pecoflyer View Post
Hi and welcome
is this some kind of homework?
It's a simulation data for a project I'm involving with.
Reply With Quote
  #4  
Old 01-27-2019, 06:19 AM
ArviLaanemets ArviLaanemets is offline How to count unique names appeared on specific date for daily report? Windows 8 How to count unique names appeared on specific date for daily report? Office 2016
Expert
 
Join Date: May 2017
Posts: 656
ArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of light
Default

Does this to work?
Attached Files
File Type: xlsx FlagsCounting.xlsx (18.4 KB, 12 views)
Reply With Quote
  #5  
Old 01-27-2019, 12:27 PM
alpha alpha is offline How to count unique names appeared on specific date for daily report? Windows 10 How to count unique names appeared on specific date for daily report? Office 2010 64bit
Novice
 
Join Date: Jun 2018
Posts: 18
alpha is on a distinguished road
Default

See attachment.
All formulas in J4:J11 and M4:P11 must be confirmed by Ctrl-Shift-Enter !
Attached Files
File Type: xlsm MSOffForums alpha.xlsm (12.8 KB, 7 views)
Reply With Quote
  #6  
Old 02-19-2019, 02:26 AM
p45cal p45cal is online now How to count unique names appeared on specific date for daily report? Windows 10 How to count unique names appeared on specific date for daily report? Office 2016
Expert
 
Join Date: Apr 2014
Posts: 544
p45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to behold
Default

Late in the day - in the attached one column added to the source table: in G4 a formula:
Code:
=SUMPRODUCT(--($A$4:$A$19=$A4),--($B$4:$B$19=$B4),($C$4:$C$19="Y")+($E$4:$E$19="Y")+($F$4:$F$19="Y")+($D$4:$D$19="Y"))
copied down.
Then 2 pivot tables (using the data model to be able to use Distinct Count)
Attached Files
File Type: xlsx msofficeforums41503Flags.xlsx (216.1 KB, 4 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count Duplicate Values without a specific Unique Value Brittni Excel 1 02-01-2017 06:22 PM
How to count unique names appeared on specific date for daily report? Counting only the unique names in 3 columns on separate worksheets. Ryga38 Excel 1 04-15-2016 07:21 AM
Create a list that contains duplicate and unique names without blanks Iced42 Excel 1 06-30-2015 04:50 PM
How to count year lapse (rounded off) based on specific date KIM SOLIS Excel 1 11-01-2011 10:50 AM
Creating Daily report forms DaveServo Excel 4 05-20-2011 03:38 AM

Other Forums: Access Forums

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


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