Spreadsheet: 868048d1714750530-calc-in-vstack-formula-with-embedded-filter-not-and-countif-excel-compare-sheet-for-copilot
Sheet: compare

Sum of Balance |  |  |  |  |  |  | 2024-04-30 00:00:00 | 2024-03-31 00:00:00 |  |  |  |  |  |  |  |  |  | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 |  | New in April |  |  |  | Removed in April
Alias |  | Date |  |  |  |  | Balance | Total | Change |  | Alias |  | Date |  |  |  |  | Balance |  |  | LC | Effective Date | Amount |  | LC | Maturity/Reprice | Amount
IS0001521 |  | 2013-06-28 00:00:00 |  |  |  |  | 4863.97 |  |  |  | IS0001521 |  | 2013-06-28 00:00:00 |  |  |  |  | 4890.74
IS0001928 |  | 2013-06-28 00:00:00 |  |  |  |  | 21075.22 |  |  |  | IS0001928 |  | 2013-06-28 00:00:00 |  |  |  |  | 21191.18
IS0002159 |  | 2013-06-28 00:00:00 |  |  |  |  | 455.81 |  |  |  | IS0002159 |  | 2013-06-28 00:00:00 |  |  |  |  | 458.32
IS0002161 |  | 2013-06-28 00:00:00 |  |  |  |  | 911.62 |  |  |  | IS0002161 |  | 2013-06-28 00:00:00 |  |  |  |  | 916.64
IS0002171 |  | 2013-06-28 00:00:00 |  |  |  |  | 911.62 |  |  |  | IS0002171 |  | 2013-06-28 00:00:00 |  |  |  |  | 916.64
IS0002180 |  | 2013-06-28 00:00:00 |  |  |  |  | 455.81 |  |  |  | IS0002180 |  | 2013-06-28 00:00:00 |  |  |  |  | 458.32
IS0002300 |  | 2013-06-28 00:00:00 |  |  |  |  | 683.72 |  |  |  | IS0002300 |  | 2013-06-28 00:00:00 |  |  |  |  | 687.48
IS0002305 |  | 2013-06-28 00:00:00 |  |  |  |  | 4786.01 |  |  |  | IS0002305 |  | 2013-06-28 00:00:00 |  |  |  |  | 4812.34
IS000230586U |  | 2021-10-18 00:00:00 |  |  |  |  | 1445000 |  |  |  | IS000230586U |  | 2021-10-18 00:00:00 |  |  |  |  | 1445000
IS0002307 |  | 2013-06-28 00:00:00 |  |  |  |  | 455.81 |  |  |  | IS0002307 |  | 2013-06-28 00:00:00 |  |  |  |  | 458.32
IS0002476 |  | 2013-06-28 00:00:00 |  |  |  |  | 50205 |  |  |  | IS0002476 |  | 2013-06-28 00:00:00 |  |  |  |  | 50205
IS000251810U |  | 2022-01-10 00:00:00 |  |  |  |  | 805000 |  |  |  | IS000251810U |  | 2022-01-10 00:00:00 |  |  |  |  | 805000
IS000263934U |  | 2022-02-24 00:00:00 |  |  |  |  | 223172.32 |  |  |  | IS000263934U |  | 2022-02-24 00:00:00 |  |  |  |  | 223202.04
IS000276494U |  | 2022-04-11 00:00:00 |  |  |  |  | 1274527.95 |  |  |  | IS000276494U |  | 2022-04-11 00:00:00 |  |  |  |  | 1274322.01
IS000285809U |  | 2022-05-27 00:00:00 |  |  |  |  | 409612.02 |  |  |  | IS000285809U |  | 2022-05-27 00:00:00 |  |  |  |  | 409612.02
IS000309372U |  | 2022-08-19 00:00:00 |  |  |  |  | 314639.33 |  |  |  | IS000309372U |  | 2022-08-19 00:00:00 |  |  |  |  | 314639.33
IS000309389U |  | 2022-08-19 00:00:00 |  |  |  |  | 2110932.54 |  |  |  | IS000309389U |  | 2022-08-19 00:00:00 |  |  |  |  | 2110932.54
IS000318348U |  | 2022-09-23 00:00:00 |  |  |  |  | 337885.3 |  |  |  | IS000318348U |  | 2022-09-23 00:00:00 |  |  |  |  | 337885.3
IS000320597U |  | 2022-10-05 00:00:00 |  |  |  |  | 3195068.05 |  |  |  | IS000320597U |  | 2022-10-05 00:00:00 |  |  |  |  | 3195068.05
IS000347436U |  | 2023-01-19 00:00:00 |  |  |  |  | 400000 |  |  |  | IS000339695U |  | 2022-12-21 00:00:00 |  |  |  |  | 318268.7
IS000355246U |  | 2023-02-24 00:00:00 |  |  |  |  | 58571.93 |  |  |  | IS000347436U |  | 2023-01-19 00:00:00 |  |  |  |  | 400000
IS000355247U |  | 2023-02-24 00:00:00 |  |  |  |  | 58571.93 |  |  |  | IS000355246U |  | 2023-02-24 00:00:00 |  |  |  |  | 58580.93
IS000355248U |  | 2023-02-27 00:00:00 |  |  |  |  | 58571.93 |  |  |  | IS000355247U |  | 2023-02-24 00:00:00 |  |  |  |  | 58580.93
IS000355249U |  | 2023-02-24 00:00:00 |  |  |  |  | 58571.93 |  |  |  | IS000355248U |  | 2023-02-27 00:00:00 |  |  |  |  | 58580.93
IS000367200U |  | 2023-04-25 00:00:00 |  |  |  |  | 998968 |  |  |  | IS000355249U |  | 2023-02-24 00:00:00 |  |  |  |  | 58580.93
IS000367202U |  | 2023-04-25 00:00:00 |  |  |  |  | 399587 |  |  |  | IS000367200U |  | 2023-04-25 00:00:00 |  |  |  |  | 998968
IS000381626U |  | 2023-06-22 00:00:00 |  |  |  |  | 177036.69 |  |  |  | IS000367202U |  | 2023-04-25 00:00:00 |  |  |  |  | 399587
IS000383356U |  | 2023-07-03 00:00:00 |  |  |  |  | 88745.35 |  |  |  | IS000381626U |  | 2023-06-22 00:00:00 |  |  |  |  | 178204
IS000386089U |  | 2023-07-14 00:00:00 |  |  |  |  | 198750 |  |  |  | IS000381898U |  | 2023-06-27 00:00:00 |  |  |  |  | 1214900
IS000394429U |  | 2023-08-18 00:00:00 |  |  |  |  | 71851.39 |  |  |  | IS000383356U |  | 2023-07-03 00:00:00 |  |  |  |  | 88758.98
IS000394430U |  | 2023-08-18 00:00:00 |  |  |  |  | 71851.39 |  |  |  | IS000386089U |  | 2023-07-14 00:00:00 |  |  |  |  | 198750
IS000394996U |  | 2023-08-21 00:00:00 |  |  |  |  | 477506.17 |  |  |  | IS000394429U |  | 2023-08-18 00:00:00 |  |  |  |  | 71862.43
IS000402394U |  | 2023-09-22 00:00:00 |  |  |  |  | 732716 |  |  |  | IS000394430U |  | 2023-08-18 00:00:00 |  |  |  |  | 71862.43
IS000402581U |  | 2023-09-22 00:00:00 |  |  |  |  | 293086 |  |  |  | IS000394996U |  | 2023-08-21 00:00:00 |  |  |  |  | 477506.17
IS000409756U |  | 2023-10-25 00:00:00 |  |  |  |  | 70219.32 |  |  |  | IS000402394U |  | 2023-09-22 00:00:00 |  |  |  |  | 732716
IS000410181U |  | 2023-10-26 00:00:00 |  |  |  |  | 3762870.33 |  |  |  | IS000402581U |  | 2023-09-22 00:00:00 |  |  |  |  | 293086
IS000410185U |  | 2023-10-26 00:00:00 |  |  |  |  | 2025625.62 |  |  |  | IS000409754U |  | 2023-10-25 00:00:00 |  |  |  |  | 70219.32
IS000410187U |  | 2023-10-26 00:00:00 |  |  |  |  | 1338645.43 |  |  |  | IS000409756U |  | 2023-10-25 00:00:00 |  |  |  |  | 70230.11
IS000410191U |  | 2023-10-26 00:00:00 |  |  |  |  | 2802422.87 |  |  |  | IS000410181U |  | 2023-10-26 00:00:00 |  |  |  |  | 3763448.35
IS000411100U |  | 2023-10-30 00:00:00 |  |  |  |  | 3945719.96 |  |  |  | IS000410185U |  | 2023-10-26 00:00:00 |  |  |  |  | 2025936.77
IS000411116U |  | 2023-10-31 00:00:00 |  |  |  |  | 1740448.03 |  |  |  | IS000410187U |  | 2023-10-26 00:00:00 |  |  |  |  | 1338851.06
IS000419456U |  | 2023-12-06 00:00:00 |  |  |  |  | 1421449.22 |  |  |  | IS000410191U |  | 2023-10-26 00:00:00 |  |  |  |  | 2802853.35
IS000429632U |  | 2024-01-17 00:00:00 |  |  |  |  | 816131.61 |  |  |  | IS000411100U |  | 2023-10-30 00:00:00 |  |  |  |  | 3946245.36
IS000429633U |  | 2024-01-17 00:00:00 |  |  |  |  | 272043.87 |  |  |  | IS000411116U |  | 2023-10-31 00:00:00 |  |  |  |  | 1740448.03
IS000429638U |  | 2024-01-19 00:00:00 |  |  |  |  | 148456.4 |  |  |  | IS000419456U |  | 2023-12-06 00:00:00 |  |  |  |  | 1421219.54
IS000431282U |  | 2024-01-24 00:00:00 |  |  |  |  | 200000 |  |  |  | IS000429632U |  | 2024-01-17 00:00:00 |  |  |  |  | 816131.61
IS000436892U |  | 2024-02-21 00:00:00 |  |  |  |  | 170000 |  |  |  | IS000429633U |  | 2024-01-17 00:00:00 |  |  |  |  | 272043.87
IS000437156U |  | 2024-02-22 00:00:00 |  |  |  |  | 129505.9 |  |  |  | IS000429638U |  | 2024-01-19 00:00:00 |  |  |  |  | 148456.4
IS000440530U |  | 2024-03-08 00:00:00 |  |  |  |  | 105000 |  |  |  | IS000431282U |  | 2024-01-24 00:00:00 |  |  |  |  | 200000
IS0004415 |  | 2013-06-28 00:00:00 |  |  |  |  | 3010.75 |  |  |  | IS000436892U |  | 2024-02-21 00:00:00 |  |  |  |  | 170000
IS0011017 |  | 2013-06-28 00:00:00 |  |  |  |  | 2770.85 |  |  |  | IS000437156U |  | 2024-02-22 00:00:00 |  |  |  |  | 129505.9
IS0025021 |  | 2013-06-28 00:00:00 |  |  |  |  | 1076800 |  |  |  | IS000440530U |  | 2024-03-08 00:00:00 |  |  |  |  | 105000
IS0163906U |  | 2014-04-04 00:00:00 |  |  |  |  | 5456.79 |  |  |  | IS0004415 |  | 2013-06-28 00:00:00 |  |  |  |  | 3027.31
IS0172686U |  | 2014-05-02 00:00:00 |  |  |  |  | 4967.37 |  |  |  | IS0011017 |  | 2013-06-28 00:00:00 |  |  |  |  | 2786.09
SC7002291W. |  | 2014-06-02 00:00:00 |  |  |  |  | 1073.55 |  |  |  | IS0025021 |  | 2013-06-28 00:00:00 |  |  |  |  | 1083900
SC7002292W |  | 2014-05-30 00:00:00 |  |  |  |  | 5073.53 |  |  |  | IS0163906U |  | 2014-04-04 00:00:00 |  |  |  |  | 5486.81
SC7002322W |  | 2014-06-18 00:00:00 |  |  |  |  | 12121.19 |  |  |  | IS0172686U |  | 2014-05-02 00:00:00 |  |  |  |  | 4994.7
SC7002895W |  | 2015-03-25 00:00:00 |  |  |  |  | 21000 |  |  |  | SC101649U |  | 2013-06-28 00:00:00 |  |  |  |  | 375000
SC7002927W |  | 2015-04-09 00:00:00 |  |  |  |  | 3238.65 |  |  |  | SC7002291W. |  | 2014-06-02 00:00:00 |  |  |  |  | 1079.46
SC7002928W |  | 2015-04-09 00:00:00 |  |  |  |  | 7280.17 |  |  |  | SC7002292W |  | 2014-05-30 00:00:00 |  |  |  |  | 5101.44
SC7002929W |  | 2015-04-09 00:00:00 |  |  |  |  | 10847.67 |  |  |  | SC7002322W |  | 2014-06-18 00:00:00 |  |  |  |  | 12187.88
SC7002930W |  | 2015-04-09 00:00:00 |  |  |  |  | 10910.71 |  |  |  | SC7002895W |  | 2015-03-25 00:00:00 |  |  |  |  | 21000
SC7002931W |  | 2015-04-09 00:00:00 |  |  |  |  | 18728.85 |  |  |  | SC7002927W |  | 2015-04-09 00:00:00 |  |  |  |  | 3256.47
SC7002932W |  | 2015-04-09 00:00:00 |  |  |  |  | 11012.13 |  |  |  | SC7002928W |  | 2015-04-09 00:00:00 |  |  |  |  | 7320.23
SC7002933W |  | 2015-04-09 00:00:00 |  |  |  |  | 3718.45 |  |  |  | SC7002929W |  | 2015-04-09 00:00:00 |  |  |  |  | 10907.35
SC7003986W |  | 2016-06-07 00:00:00 |  |  |  |  | 27600 |  |  |  | SC7002930W |  | 2015-04-09 00:00:00 |  |  |  |  | 10970.75
SC7004179W |  | 2016-10-03 00:00:00 |  |  |  |  | 9592.95 |  |  |  | SC7002931W |  | 2015-04-09 00:00:00 |  |  |  |  | 18831.9
SC7004921W |  | 2017-09-21 00:00:00 |  |  |  |  | 158274.54 |  |  |  | SC7002932W |  | 2015-04-09 00:00:00 |  |  |  |  | 11072.72
SC7004991W |  | 2017-11-03 00:00:00 |  |  |  |  | 30720.37 |  |  |  | SC7002933W |  | 2015-04-09 00:00:00 |  |  |  |  | 3738.91
SC7005590W |  | 2018-11-01 00:00:00 |  |  |  |  | 1225390.5 |  |  |  | SC7003986W |  | 2016-06-07 00:00:00 |  |  |  |  | 27600
SC7005650W |  | 2018-12-07 00:00:00 |  |  |  |  | 2046168.2 |  |  |  | SC7004179W |  | 2016-10-03 00:00:00 |  |  |  |  | 9592.95
SC7005747W |  | 2019-01-25 00:00:00 |  |  |  |  | 244593.29 |  |  |  | SC7004921W |  | 2017-09-21 00:00:00 |  |  |  |  | 159145.41
SC7005765W |  | 2019-02-13 00:00:00 |  |  |  |  | 131721.19 |  |  |  | SC7004991W |  | 2017-11-03 00:00:00 |  |  |  |  | 30889.4
SC7005892W |  | 2019-04-25 00:00:00 |  |  |  |  | 902178 |  |  |  | SC7005590W |  | 2018-11-01 00:00:00 |  |  |  |  | 1225192.5
SC7005924W |  | 2019-05-16 00:00:00 |  |  |  |  | 108923.6 |  |  |  | SC7005650W |  | 2018-12-07 00:00:00 |  |  |  |  | 2059659.84
SC7006140W |  | 2019-10-23 00:00:00 |  |  |  |  | 117192.95 |  |  |  | SC7005747W |  | 2019-01-25 00:00:00 |  |  |  |  | 246206.04
SC7006236W |  | 2019-11-29 00:00:00 |  |  |  |  | 1241657.96 |  |  |  | SC7005765W |  | 2019-02-13 00:00:00 |  |  |  |  | 132445.95
SC7006259W |  | 2019-12-09 00:00:00 |  |  |  |  | 104748.65 |  |  |  | SC7005892W |  | 2019-04-25 00:00:00 |  |  |  |  | 902178
SC7006260W |  | 2019-12-09 00:00:00 |  |  |  |  | 104748.65 |  |  |  | SC7005924W |  | 2019-05-16 00:00:00 |  |  |  |  | 108906
SC7006328W |  | 2020-01-23 00:00:00 |  |  |  |  | 53833.49 |  |  |  | SC7006140W |  | 2019-10-23 00:00:00 |  |  |  |  | 117210.96
SC7006432W |  | 2020-04-02 00:00:00 |  |  |  |  | 611693.74 |  |  |  | SC7006235W |  | 2019-11-29 00:00:00 |  |  |  |  | 313562.06
SC7006687W |  | 2020-08-04 00:00:00 |  |  |  |  | 181500 |  |  |  | SC7006236W |  | 2019-11-29 00:00:00 |  |  |  |  | 1241848.69
SC7006930W |  | 2020-12-02 00:00:00 |  |  |  |  | 8682.82 |  |  |  | SC7006238W |  | 2019-11-29 00:00:00 |  |  |  |  | 101170.78
SC7007062W |  | 2021-02-11 00:00:00 |  |  |  |  | 42000 |  |  |  | SC7006239W |  | 2019-11-29 00:00:00 |  |  |  |  | 413586.28
SM229357 |  | 2013-06-28 00:00:00 |  |  |  |  | 750000 |  |  |  | SC7006242W |  | 2019-11-29 00:00:00 |  |  |  |  | 131602.63
SM235256 |  | 2013-06-28 00:00:00 |  |  |  |  | 975307 |  |  |  | SC7006243W |  | 2019-11-29 00:00:00 |  |  |  |  | 177690.06
SM235483 |  | 2013-06-28 00:00:00 |  |  |  |  | 12444.44 |  |  |  | SC7006259W |  | 2019-12-09 00:00:00 |  |  |  |  | 104764.74
SM235484 |  | 2013-07-31 00:00:00 |  |  |  |  | 120200 |  |  |  | SC7006260W |  | 2019-12-09 00:00:00 |  |  |  |  | 104764.74
SM237999 |  | 2013-06-28 00:00:00 |  |  |  |  | 13086.55 |  |  |  | SC7006328W |  | 2020-01-23 00:00:00 |  |  |  |  | 54129.7
SM238005 |  | 2013-06-28 00:00:00 |  |  |  |  | 2848.81 |  |  |  | SC7006432W |  | 2020-04-02 00:00:00 |  |  |  |  | 615727.01
SM238145 |  | 2013-06-28 00:00:00 |  |  |  |  | 5235.82 |  |  |  | SC7006687W |  | 2020-08-04 00:00:00 |  |  |  |  | 181500
[NAME] |  | 2013-06-28 00:00:00 |  |  |  |  | 1187.51 |  |  |  | SC7006930W |  | 2020-12-02 00:00:00 |  |  |  |  | 8730.6
SM238147 |  | 2013-06-28 00:00:00 |  |  |  |  | 539.78 |  |  |  | SC7007062W |  | 2021-02-11 00:00:00 |  |  |  |  | 42000
SM238560 |  | 2013-06-28 00:00:00 |  |  |  |  | 2303.04 |  |  |  | SM229357 |  | 2013-06-28 00:00:00 |  |  |  |  | 1050000
SM239064 |  | 2013-06-28 00:00:00 |  |  |  |  | 4992.32 |  |  |  | SM235256 |  | 2013-06-28 00:00:00 |  |  |  |  | 975307
Grand Total |  |  |  |  |  |  | 43730943.2 |  |  |  | SM235483 |  | 2013-06-28 00:00:00 |  |  |  |  | 12444.44
 |  |  |  |  |  |  |  |  |  |  | SM235484 |  | 2013-07-31 00:00:00 |  |  |  |  | 120200
 |  |  |  |  |  |  |  |  |  |  | SM237999 |  | 2013-06-28 00:00:00 |  |  |  |  | 13158.55
 |  |  |  |  |  |  |  |  |  |  | SM238005 |  | 2013-06-28 00:00:00 |  |  |  |  | 2864.49
 |  |  |  |  |  |  |  |  |  |  | SM238145 |  | 2013-06-28 00:00:00 |  |  |  |  | 5264.63
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 2013-06-28 00:00:00 |  |  |  |  | 1194.04
 |  |  |  |  |  |  |  |  |  |  | SM238147 |  | 2013-06-28 00:00:00 |  |  |  |  | 542.75
 |  |  |  |  |  |  |  |  |  |  | SM238560 |  | 2013-06-28 00:00:00 |  |  |  |  | 2315.71
 |  |  |  |  |  |  |  |  |  |  | SM239064 |  | 2013-06-28 00:00:00 |  |  |  |  | 5019.79
 |  |  |  |  |  |  |  |  |  |  | Grand Total |  |  |  |  |  |  | 47179117.13000001