Counting Once a Day a item in a list

[Chrisa1956]

Hello All,

I need to figure out how to count the Name column, if it existing in a list, but only once per day.

Below is the first set of data. The count is the result I am trying to get to.

Name	Date	QTY	Count
mjones	07/30/2019	2.00	0
fjones	07/30/2019	7.50	1
fjones	07/30/2019	3.50	0
gjones	07/30/2019	5.00	1
gjones	07/30/2019	3.50	0
sjones	07/30/2019	2.50	1

<tbody>
</tbody>

The list it needs to check. This is in another sheet.

Name

fjones

gjones

sjones

<tbody>
</tbody>

 

[Twollaston]

Hello All,

I need to figure out how to count the Name column, if it existing in a list, but only once per day.

Below is the first set of data. The count is the result I am trying to get to.

Name	Date	QTY	Count
mjones	07/30/2019	2.00	0
fjones	07/30/2019	7.50	1
fjones	07/30/2019	3.50	0
gjones	07/30/2019	5.00	1
gjones	07/30/2019	3.50	0
sjones	07/30/2019	2.50	1

<tbody>
</tbody>

something like =IF(COUNTIF($A$2:A2,A2)>1,0,1) maybe, if i'm understanding correctly
assuming name is in A column
not sure about the date qualifier tbh

 

[Marcelo Branco]

Welcome To Mr Excel forum

Maybe
D2 copied down
=IF(COUNTIF(Names,A2),--(COUNTIFS(A$2:A2,A2,B$2:B2,B2)=1),0)

where Names is a named range that contains the names of interest

M.

 

[Chrisa1956]

Welcome To Mr Excel forum

Maybe
D2 copied down
=IF(COUNTIF(Names,A2),--(COUNTIFS(A$2:A2,A2,B$2:B2,B2)=1),0)

where Names is a named range that contains the names of interest

M.

That worked. I have beat my head against the wall. Try to get this to work.

Thanks

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.