separate duplicate values in multiple criteria

[sumsaam]

Hi All,
This is sample of my attendence sheet i get the values of time punch of employees through multiple criteria formula. problem is that if an employees has two or more punches in same date. i want to get both values in saparate cells. multiple criteria gives only first value of same date same employee. how to get second value of same date and same employee. Thank you

26-04-2023.xlsx
	A	B	C	D
1	Emp ID	First Name	Date	Time
2	4	Afaq	19-04-2023	00:38
3	4	Afaq	19-04-2023	12:44
4	4	Afaq	19-04-2023	13:25
5	4	Afaq	19-04-2023	14:15
6	4	Afaq	20-04-2023	01:01
7	4	Afaq	20-04-2023	12:24
8	5	Shahzaib	19-04-2023	00:45
9	5	Shahzaib	19-04-2023	12:12
10	5	Shahzaib	20-04-2023	01:09
11	5	Shahzaib	20-04-2023	14:29
12	6	Uzair	19-04-2023	00:48
13	6	Uzair	19-04-2023	12:12
14	6	Uzair	19-04-2023	15:15
15	6	Uzair	19-04-2023	19:36
16	6	Uzair	20-04-2023	01:09
17	6	Uzair	20-04-2023	13:55
Sheet

 

[Joe4]

Duplicate to: Duplicates in Multiple criteria

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.