Outliers using Index Match function

[Hiten_pan]

Hi friends,


I am working on a project where I would need below raw data to show expected results as shown below.
Basically, it is an outlier report where only "Check Accts" will be flagged. Thanks!!!
I am looking for the formulae without {} brackets, it maybe combination of Index Match function

Raw data

Unique #	Acct	Cusip	Direction	Broker Accruals	PIMCO Accruals
695CCHUSIUS4	695	CCHUSIUS4	IP	1738.51	1733.52
1023CCHUSIUS4	1023	CCHUSIUS4	IP	1109.51	1076.08
3199CCHUSIUS4	3199	CCHUSIUS4	IP	1099.89	CHECK Acct#
1203CCHUSIUS4	1203	CCHUSIUS4	IP	772.23	773.85
2755CCHUSIUS4	2755	CCHUSIUS4	IP	417.71	417.66
96CCHUSIUS4	96	CCHUSIUS4	IP	194.31	194.57
2462CCHUSIUS4	2462	CCHUSIUS4	IP	181.3	181.55
3684CCHUSIUS4	3684	CCHUSIUS4	IP	119.94	120
7893CCHUSIUS4	7893	CCHUSIUS4	IP	85.5	CHECK Acct#
935CCHUSIUS4	935	CCHUSIUS4	IP	80.13	80.13

<tbody>
</tbody><colgroup><col><col><col><col><col><col></colgroup>

Expected results

PIMCO Accruals	Unique #
CHECK Acct#	3199CCHUSIUS4
CHECK Acct#	7893CCHUSIUS4

<tbody>
</tbody><colgroup><col><col></colgroup>

 

[sheetspread]

Why not just filter?

 

[Hiten_pan]

Hi

I am working on a automation project where this formaule will key role to eliminate risk