#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
It's a simulation data for a project I'm involving with.
|
#4
|
|||
|
|||
Does this to work?
|
#5
|
|||
|
|||
See attachment.
All formulas in J4:J11 and M4:P11 must be confirmed by Ctrl-Shift-Enter ! |
#6
|
||||
|
||||
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")) Then 2 pivot tables (using the data model to be able to use Distinct Count) |
|
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 |
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 |