Identify if all values within multiple rows for a specific value in another cell all contain a specific value return a specific result, example in msg

[perfected_tipoff920]

I am trying to identify based on if a specific USERNAME what ACCESS_TYPE they have based on the evaluation of all the values of RESPONSIBILITY_TYPE
what formula can I use in Col G to obtain these results?
Thanks

If same username has all responsibility_types = 'READ_ONLY' then ACCESS_TYPE = 'READ_ONLY'
If same username has all responsibility_types = 'READ/WRITE' then ACCESS_TYPE = 'READ/WRITE'
If same username has all responsibility_type contains both 'READ-ONLY' and 'READ/WRITE' then ACCESS_TYPE = 'MIXED'

Expected Results for all rows of JDOE in ACCESS_TYPE would be 'READ_ONLY', for JBLOGGS would be 'READ/WRITE' for FNERK would be 'MIXED'


BEFORE

	A	B	C	D	E	F	G
1	DEPT	EMP_NO	USERNAME	NAME	RESPONSIBILITY	RESPONSIBILITY_TYPE	ACCESS_TYPE
2	IT	555	JDOE	JOHN DOE	FINANCE_INQUIRY	READ-ONLY
3	IT	555	JDOE	JOHN DOE	BILLING_INQUIRY	READ-ONLY
4	IT	555	JDOE	JOHN DOE	SALES_INQUIRY	READ-ONLY
5	BILLING	111	JBLOGGS	JOE BLOGGS	BILLING_CLERK	READ/WRITE
6	BILLING	111	JBLOGGS	JOE BLOGGS	INVOICE_MGR	READ/WRITE
7	BILLING	333	FNERK	FRED NERK	BILLING_CLERK	READ/WRITE
8	BILLING	333	FNERK	FRED NERK	FINANCE_INQUIRY	READ-ONLY

EXPECTED RESULTS

	A	B	C	D	E	F	G
1	DEPT	EMP_NO	USERNAME	NAME	RESPONSIBILITY	RESPONSIBILITY_TYPE	ACCESS_TYPE
2	IT	555	JDOE	JOHN DOE	FINANCE_INQUIRY	READ-ONLY	READ_ONLY
3	IT	555	JDOE	JOHN DOE	BILLING_INQUIRY	READ-ONLY	READ_ONLY
4	IT	555	JDOE	JOHN DOE	SALES_INQUIRY	READ-ONLY	READ_ONLY
5	BILLING	111	JBLOGGS	JOE BLOGGS	BILLING_CLERK	READ/WRITE	READ/WRITE
6	BILLING	111	JBLOGGS	JOE BLOGGS	INVOICE_MGR	READ/WRITE	READ/WRITE
7	BILLING	333	FNERK	FRED NERK	BILLING_CLERK	READ/WRITE	MIXED
8	BILLING	333	FNERK	FRED NERK	FINANCE_INQUIRY	READ-ONLY	MIXED

 

[JamesCanale]

In G2-G8:

=LET(a,UNIQUE(FILTER($F$2:$F$8,$B$2:$B$8=B2)),IF(ROWS(a)=1,a,"MIXED"))

 

[perfected_tipoff920]

In G2-G8:

=LET(a,UNIQUE(FILTER($F$2:$F$8,$B$2:$B$8=B2)),IF(ROWS(a)=1,a,"MIXED"))

Thanks, worked perfectly. Saved me vasts amount of time. Appreciate it