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
<tbody>
</tbody>
Expected results
<tbody>
</tbody>
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>
Expected results
PIMCO Accruals | Unique # |
CHECK Acct# | 3199CCHUSIUS4 |
CHECK Acct# | 7893CCHUSIUS4 |
<tbody>
</tbody>