Fantastic Challenge. Thank You ??

My answer to Q.2 is 48 . . NOT 49.

A.1)
LET(emp, ISNUMBER(XMATCH(trainings[EMP ID], staff[EMP ID])),
trng, ISNUMBER(XMATCH(trainings[COURSE ID], {"CM101","CC101","EAT101"})),
comp, trainings[PASS/FAIL] = "Pass",
a, GROUPBY(trainings[EMP ID], emp * trng * comp, SUM, , 0, , emp),
result, SUM(--(CHOOSECOLS(a, 2) = 3)),
result)

A.2)
LET(emp, ISNUMBER(XMATCH(trainings[EMP ID], staff[EMP ID])),
trng, ISNUMBER(XMATCH(trainings[COURSE ID], {"CM101","CC101","EAT101"})),
comp, trainings[PASS/FAIL] = "Pass",
a, GROUPBY(trainings[EMP ID], emp * trng * comp, SUM, , 0, , emp),
result, SUM(--(CHOOSECOLS(a, 2) >= 1)),
result)

A.3)
SUM(--(NOT(ISNUMBER(XMATCH(staff[EMP ID], trainings[EMP ID])))))

Best Wishes!

Any duplicates
=REGEXTEST(A1, "(\d).*(\g1)")

Any adjacent duplicates
=REGEXTEST(A1, "(\d)(\g1)")

\d -- Match any digit 0-9
.* -- Match any text of any length
() -- Capture group (allows a match to be referenced later)
(\g1) -- Match whatever was matched in capture group 1 (i.e., whatever digit 0-9 was matched, try to match it again)

Feels like cheating compared to the creative solutions offered by others!

for IF formula i am geting this payout,here is my formula

=IF($C4=0%,1500,IF(AND($C4>0%,$C4<3%),1000,0))+IF(IF($E4<500,1000,0)=1000,1000,IF($F4=1,1000,0)+IF($D4>=98%,1500,IF($D4>=96%,500,0))+IF(AND($C4=96%,OR($E4<500,$F4<560),$G4=1),5000,0)

but for EMP0002 my answer is 2500 buy your answer is 2000.

Thank you very much for your great effort to help us learn these topics.

I found the content so useful and valuable.
Thank you again for sharing your knowledge.

Regards.

Sanath.

Budget Amount 41500