Spreadsheet: 756421d1637530987-calculating-xirr-on-non-contiguous-rows-and-columns-based-on-criteria-xirr-non-contigous-rows-and-cols
Sheet: XIRR -Non-Contigous Rows & Cols

Scheme Name | Last recorded NAV On | XIRR Amount | Latest Date | Total Value |  |  | Scheme Name | Last recorded NAV On | XIRR Amount | Latest Date | Total Value
Fund 1 | 2021-08-31 00:00:00 | -2000 | 2021-11-18 00:00:00 | 6279.581294 |  |  | Fund 1 | 2021-08-31 00:00:00 | -2000 | 2021-11-18 00:00:00 | 6279.581294
Fund 2 | 2021-09-01 00:00:00 | -1500 | 2021-11-18 00:00:00 | 4672.274562000001 |  |  | Fund 1 | 2021-10-01 00:00:00 | -2000 | 2021-11-18 00:00:00
Fund 3 | 2021-09-01 00:00:00 | -2000 | 2021-11-18 00:00:00 | 6249.3580323 |  |  | Fund 1 | 2021-11-01 00:00:00 | -2000 | 2021-11-18 00:00:00
Fund 4 | 2021-09-01 00:00:00 | -1500 | 2021-11-18 00:00:00 | 4694.112 |  |  | Fund 1 | 2021-11-18 00:00:00 | 6279.581294
Fund 5 | 2021-09-01 00:00:00 | -1500 | 2021-11-18 00:00:00 | 4593.97975
Fund 6 | 2021-09-01 00:00:00 | -1500 | 2021-11-18 00:00:00 | 4813.247190000001
Fund 7 | 2021-09-01 00:00:00 | -2000 | 2021-11-18 00:00:00 | 6331.484880000001
Fund 8 | 2021-09-01 00:00:00 | -1000 | 2021-11-18 00:00:00 | 3126.6024 |  |  |  |  |  | +0.1 | +0.9
Fund 5 | 2021-10-01 00:00:00 | -1500 | 2021-11-18 00:00:00 |  |  |  | Fund 1
Fund 6 | 2021-10-01 00:00:00 | -1500 | 2021-11-18 00:00:00 |  |  |  | Fund 2
Fund 7 | 2021-10-01 00:00:00 | -2000 | 2021-11-18 00:00:00 |  |  |  | Fund 3
Fund 8 | 2021-10-01 00:00:00 | -1000 | 2021-11-18 00:00:00 |  |  |  | Fund 4
Fund 1 | 2021-10-01 00:00:00 | -2000 | 2021-11-18 00:00:00 |  |  |  | Fund 5
Fund 2 | 2021-10-01 00:00:00 | -1500 | 2021-11-18 00:00:00 |  |  |  | Fund 6
Fund 4 | 2021-10-01 00:00:00 | -1500 | 2021-11-18 00:00:00 |  |  |  | Fund 7
Fund 3 | 2021-10-01 00:00:00 | -2000 | 2021-11-18 00:00:00 |  |  |  | Fund 8
Fund 9 | 2021-10-04 00:00:00 | -5000 | 2021-11-18 00:00:00 | 5226.309139999999 |  |  | Fund 9
Fund 10 | 2021-10-04 00:00:00 | -5000 | 2021-11-18 00:00:00 | 7556.3515941 |  |  | Fund 10
Fund 11 | 2021-10-18 00:00:00 | -1000 | 2021-11-18 00:00:00 | 21083.2023216 |  |  | Fund 11
Fund 11 | 2021-10-18 00:00:00 | -9000 | 2021-11-18 00:00:00 |  |  |  | Fund 12
Fund 11 | 2021-10-27 00:00:00 | -1000 | 2021-11-18 00:00:00
Fund 12 | 2021-10-26 00:00:00 | -1000 | 2021-11-18 00:00:00 | 11000
Fund 12 | 2021-10-26 00:00:00 | -9000 | 2021-11-18 00:00:00 |  |  |  |  |  |  | 44440.1 | 44440.9
Fund 11 | 2021-10-27 00:00:00 | -9000 | 2021-11-18 00:00:00 |  |  |  |  |  |  | 44440.1 | 44440.9
Fund 10 | 2021-11-01 00:00:00 | -2500 | 2021-11-18 00:00:00 |  |  |  |  |  |  | 44440.1 | 44440.9
Fund 1 | 2021-11-01 00:00:00 | -2000 | 2021-11-18 00:00:00 |  |  |  |  |  |  | 44440.1 | 44440.9
Fund 7 | 2021-11-01 00:00:00 | -2000 | 2021-11-18 00:00:00 |  |  |  |  |  |  | 44440.1 | 44440.9
Fund 6 | 2021-11-01 00:00:00 | -1500 | 2021-11-18 00:00:00 |  |  |  |  |  |  | 44440.1 | 44440.9
Fund 5 | 2021-11-01 00:00:00 | -1500 | 2021-11-18 00:00:00 |  |  |  |  |  |  | 44440.1 | 44440.9
Fund 4 | 2021-11-01 00:00:00 | -1500 | 2021-11-18 00:00:00 |  |  |  |  |  |  | 44470.1 | 44470.9
Fund 3 | 2021-11-01 00:00:00 | -2000 | 2021-11-18 00:00:00 |  |  |  |  |  |  | 44470.1 | 44470.9
Fund 2 | 2021-11-01 00:00:00 | -1500 | 2021-11-18 00:00:00 |  |  |  |  |  |  | 44470.1 | 44470.9
Fund 8 | 2021-11-01 00:00:00 | -1000 | 2021-11-18 00:00:00 |  |  |  |  |  |  | 44470.1 | 44470.9
 |  |  |  |  |  |  |  |  |  | 44470.1 | 44470.9
 |  |  |  |  |  |  |  |  |  | 44470.1 | 44470.9
 |  |  |  |  |  |  |  |  |  | 44470.1 | 44470.9
 |  |  |  |  |  |  |  |  |  | 44470.1 | 44470.9
 |  |  |  |  |  |  |  |  |  | 44473.1 | 44473.9
 |  |  |  |  |  |  |  |  |  | 44473.1 | 44473.9
 |  |  |  |  |  |  |  |  |  | 44487.1 | 44487.9
 |  |  |  |  |  |  |  |  |  | 44487.1 | 44487.9
 |  |  |  |  |  |  |  |  |  | 44496.1 | 44496.9
 |  |  |  |  |  |  |  |  |  | 44495.1 | 44495.9
 |  |  |  |  |  |  |  |  |  | 44495.1 | 44495.9
 |  |  |  |  |  |  |  |  |  | 44496.1 | 44496.9
 |  |  |  |  |  |  |  |  |  | 44501.1 | 44501.9
 |  |  |  |  |  |  |  |  |  | 44501.1 | 44501.9
 |  |  |  |  |  |  |  |  |  | 44501.1 | 44501.9
 |  |  |  |  |  |  |  |  |  | 44501.1 | 44501.9
 |  |  |  |  |  |  |  |  |  | 44501.1 | 44501.9
 |  |  |  |  |  |  |  |  |  | 44501.1 | 44501.9
 |  |  |  |  |  |  |  |  |  | 44501.1 | 44501.9
 |  |  |  |  |  |  |  |  |  | 44501.1 | 44501.9
 |  |  |  |  |  |  |  |  |  | 44501.1 | 44501.9
 |  |  |  |  |  |  |  |  |  | 44518.1 | 44518.9