Multiple Criteria to get Particular Output

Tab 1 H2:
=IF(MIN(IF(((INT($B$2:$B$175)=INT(B2))*($A$2:$A$175=A2)),$C$2:$C$175))=C2,"First Login","")

This is an array formula confirmed with Ctrl+Shift+Enter

Tab 2 H2:
=IF(MAX(IF(((INT($B$2:$B$175)=INT(B2))*($A$2:$A$175=A2)),$C$2:$C$175))=C2,"Last Logout","")

This is an array formula confirmed with Ctrl+Shift+Enter

Everything is possible. Give me a moment.

C2:
=IFERROR(LOOKUP(2,1/(('Agent Log In'!$A$2:$A$175=Combined!$B2)*('Agent Log In'!$B$2:$B$175=Combined!C$1)*('Agent Log In'!$H$2:$H$175<>"")),'Agent Log In'!$G$2:$G$175),"-")

copy over and down

C7:
=IFERROR(LOOKUP(2,1/(('Agent Log Out'!$A$2:$A$177=Combined!$B7)*('Agent Log Out'!$B$2:$B$177=Combined!C$6)*('Agent Log Out'!$H$2:$H$177<>"")),'Agent Log Out'!$G$2:$G$177),"-")

copy over and down

INDEX(..MATCH( is a great tool. LOOKUP(2,1/(()*()),) does the same thing but lets you nest lots of conditions into it. And it's not an Array formula... (unless you smoosh MIN and MAX into it)

Could potentially smoosh all of the formulas into one. Let me try.

Here we go:

C2:

Please Login or Register  to view this content.

This is another array formula confirmed with Ctrl+Shift+Enter

With this, you won't need to even enter the formula from post 2 into Column H.

And here's C7:

Please Login or Register  to view this content.