Date conditioning

[fathima]

Hi Need help with this.
If same ticket number under C is dispatched on even another day i need the value to be showing as 1 (under productivity) against my name.
Please refer to the current formula where its filtering based on different dates, i need value as 1 if same ticket assigned to same person on even different date.


Formula:
=IFNA(INDEX($F$6:$F$1000000,MATCH(J6,$E$6:$E$1000000,0),),0)

A B C D E F G H I J

SL NO​	Date​	TICKETS DISPATCHED​	TICKET TYPE​	ASSIGNEE​	COUNT​	DISPATCHER​	COUNT​	productivity​	​
1​	19th sept​	INC123​	​	Fathima Balquees​	1​	​	0​	2​	Fathima Balquees​
2​	19th sept​	INC123​	​	Fathima Balquees​	1​	​	0​	0​	​
3​	20th sept​	INC123​	​	Fathima Balquees​	1​	​	0​	0​	​

 

[Toadstool]

Hi Fathima,
I'm struggling to understand the requirement.
I don't see how Productivity can be 2 for your first data row as INDEX returns zero or if your name is in column E then the first match in that column and with every Count being 1 it must return 1.

Please take a look at this data and indicate all values you'd expect in Productivity.

Book1
	A	B	C	D	E	F	G	H	I	J
1
2
3	SL NO	Date	TICKETS DISPATCHED	TICKET TYPE	ASSIGNEE	COUNT	DISPATCHER	COUNT	productivity
4	1	19-Sep-21	INC123		Fathima Balquees	1		0	?	Fathima Balquees
5	2	19-Sep-21	INC123		Fathima Balquees	1		0	?
6	3	20-Sep-21	INC123		Fathima Balquees	1		0	?
7	4	20-Sep-21	INC123		Fathima Balquees	1		0	?
8	5	21-Sep-21	INC123		James Smith	1		0	?
9	6	22-Sep-21	INC123		Fathima Balquees	1		0	?
10	7	22-Sep-21	INC123		Fathima Balquees	5		0	?
Sheet1

 

[Alex Blakenburg]

I am only guessing here, but is this what you mean ?
@Toadstool - just leveraging off your XL2BB

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	SL NO	Date	TICKETS DISPATCHED	TICKET TYPE	ASSIGNEE	COUNT	DISPATCHER	COUNT	productivity
2	1	19-Sep-21	INC123		Fathima Balquees	1		0	1	Fathima Balquees
3	2	19-Sep-21	INC123		Fathima Balquees	1		0	0
4	3	20-Sep-21	INC123		Fathima Balquees	1		0	0
5	4	20-Sep-21	INC123		Fathima Balquees	1		0	0
6	5	21-Sep-21	INC123		James Smith	1		0	1
7	6	22-Sep-21	INC123		Fathima Balquees	1		0	0
8	7	22-Sep-21	INC123		Fathima Balquees	5		0	0
9	8	19-Sep-21	INC130		Fathima Balquees	1		0	1
10	9	22-Sep-21	INC130		Fathima Balquees	1		0	0
11
Data

Cell Formulas
Range	Formula
I2:I10	I2	=--(COUNTIFS($C$2:$C2,$C2,$E$2:$E2,$E2)=1)