database example.xlsx

Day
Time
7/9/2006
10:00
7/9/2006
10:15
7/9/2006
10:30
7/9/2006
10:45
7/9/2006
11:00
7/10/2006
11:15
7/10/2006
11:30
Individuals in group
MK, AO, BT, CAT, JOL, LIT
MK, AO, BT, JK, CAT, JOL
MK, AO, BT, JK, CAT, JOL
MK, AO, BT, CAT, JOL
MK, AO, BT, LIT
MK, AO, BT
MK, AO, BT, CSN
MK, AO, BT, MAY
Females in group/day
CAT, JOL, LIT
CAT, JOL, LIT
CAT, JOL, LIT
CAT, JOL, LIT
CAT, JOL, LIT
CAT, JOL, LIT
MAY, CSN
MAY, CSN
Females in group/scan
CAT, JOL, LIT
CAT, JOL
CAT, JOL
CAT, JOL
LIT
CSN
MAY
I am creating the "females in group/scan" field. I want to create a script that looks at the field "females in group/day", checks if there is a match within the same record in the field "individuals in group" and enters those characters into the field "females in group/scan".