Spreadsheet: 845668d1697081647-i-need-a-help-in-two-type-of-excel-situations-book-excel-results
Sheet: Sheet1

Security  Code | Maturity Date | Customer Name | CCY | Issue Date | Face Value of Investment | Tenor of INPCs | Profit | No. of | PROFIT OCT 20 | Profit | No. of | PROFIT NOV 20 | Profit | No. of | PROFIT DEC 20 | Profit | No. of | PROFIT JAN 21 | Profit | No. of | PROFIT FEB 21 | Profit | No. of | PROFIT MAR 21 | Profit | No. of | PROFIT APR 21 | Profit | No. of | PROFIT May 21 | Profit | No. of | PROFIT June 21 | Profit | No. of | PROFIT July 21 | Profit | No. of | PROFIT Aug 21 | Profit | No. of | PROFIT Sep 21 | Profit | No. of | PROFIT 0ct 21 | Profit | No. of | PROFIT Nov 21 | Profit | No. of | PROFIT Dec 21 | Profit | No. of | PROFIT Jan 22 | Profit | No. of | PROFIT Feb 22 | Profit | No. of | PROFIT Mar 22 | Profit | No. of | PROFIT Apr 22 | Profit | No. of | PROFIT May 22 | Profit | No. of | PROFIT Jun 22 | Profit | No. of | PROFIT Jul 22 | Profit | No. of | PROFIT Aug 22 | Profit | No. of | PROFIT Sep 22 | Profit | No. of | PROFIT Oct 22 | Profit | No. of | PROFIT Nov 22 | Profit | No. of | PROFIT Dec 22 | Profit | No. of | PROFIT Jan 23 | Profit | No. of | PROFIT Feb 23 | Profit | No. of | PROFIT Mar 23 | Profit | No. of | PROFIT Apr 23 | Profit | No. of | PROFIT May 23 | Profit | No. of | PROFIT Jun 23 | Profit | No. of | PROFIT Jul 23 | Profit | No. of | PROFIT Aug 23 | Profit | No. of | PROFIT Sep 23 | Profit | No. of | PROFIT Oct 23 | TOTAL PROFIT
 |  |  |  |  |  |  |  |  | 2020-10-01 00:00:00 |  |  | 2020-11-01 00:00:00 |  |  | 2020-12-01 00:00:00 |  |  | 2021-01-01 00:00:00 |  |  | 2021-02-01 00:00:00 |  |  | 2021-03-01 00:00:00 |  |  | 2021-04-01 00:00:00 |  |  | 2021-05-01 00:00:00 |  |  | 2021-06-01 00:00:00 |  |  | 2021-07-01 00:00:00 |  |  | 2021-08-01 00:00:00 |  |  | 2021-09-01 00:00:00 |  |  | 2021-10-01 00:00:00 |  |  | 2021-11-01 00:00:00 |  |  | 2021-12-01 00:00:00 |  |  | 2022-01-01 00:00:00 |  |  | 2022-02-01 00:00:00 |  |  | 2022-03-01 00:00:00 |  |  | 2022-04-01 00:00:00 |  |  | 2022-05-01 00:00:00 |  |  | 2022-06-01 00:00:00 |  |  | 2022-07-01 00:00:00 |  |  | 2022-08-01 00:00:00 |  |  | 2022-09-01 00:00:00 |  |  | 2022-10-01 00:00:00 |  |  | 2022-11-01 00:00:00 |  |  | 2022-12-01 00:00:00 |  |  | 2023-01-01 00:00:00 |  |  | 2023-02-01 00:00:00 |  |  | 2023-03-01 00:00:00 |  |  | 2023-04-01 00:00:00 |  |  | 2023-05-01 00:00:00 |  |  | 2023-06-01 00:00:00 |  |  | 2023-07-01 00:00:00 |  |  | 2023-08-01 00:00:00 |  |  | 2023-09-01 00:00:00 |  |  | 2023-10-01 00:00:00
 |  |  |  |  |  |  | Rate % | Days | 2020-10-31 00:00:00 | Rate % | Days | 2020-11-30 00:00:00 | Rate % | Days | 2020-12-31 00:00:00 | Rate % | Days | 2021-01-31 00:00:00 | Rate % | Days | 2021-02-28 00:00:00 | Rate % | Days | 2021-03-31 00:00:00 | Rate % | Days | 2021-04-30 00:00:00 | Rate % | Days | 2021-05-31 00:00:00 | Rate % | Days | 2021-06-30 00:00:00 | Rate % | Days | 2021-07-31 00:00:00 | Rate % | Days | 2021-08-31 00:00:00 | Rate % | Days | 2021-09-30 00:00:00 | Rate % | Days | 2021-10-31 00:00:00 | Rate % | Days | 2021-11-30 00:00:00 | Rate % | Days | 2021-12-31 00:00:00 | Rate % | Days | 2022-01-31 00:00:00 | Rate % | Days | 2022-02-28 00:00:00 | Rate % | Days | 2022-03-31 00:00:00 | Rate % | Days | 2022-04-30 00:00:00 | Rate % | Days | 2022-05-31 00:00:00 | Rate % | Days | 2022-06-30 00:00:00 | Rate % | Days | 2022-07-31 00:00:00 | Rate % | Days | 2022-08-31 00:00:00 | Rate % | Days | 2022-09-30 00:00:00 | Rate % | Days | 2022-10-31 00:00:00 | Rate % | Days | 2022-11-30 00:00:00 | Rate % | Days | 2022-12-31 00:00:00 | Rate % | Days | 2023-01-31 00:00:00 | Rate % | Days | 2023-02-28 00:00:00 | Rate % | Days | 2023-03-31 00:00:00 | Rate % | Days | 2023-04-30 00:00:00 | Rate % | Days | 2023-05-31 00:00:00 | Rate % | Days | 2023-06-30 00:00:00 | Rate % | Days | 2023-07-31 00:00:00 | Rate % | Days | 2023-08-31 00:00:00 | Rate % | Days | 2023-09-30 00:00:00 | Rate % | Days | 2023-10-31 00:00:00
 |  |  | 2023-01-23 00:00:00 | 2022-09-15 00:00:00 |  |  | 2020-10-01 00:00:00 | 2020-10-01 00:00:00 | 31 | 2020-11-01 00:00:00 | 2020-11-01 00:00:00 | 30 | 2020-12-01 00:00:00 | 2020-12-01 00:00:00 | 31 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 31 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00 | 28 | 2021-03-01 00:00:00 | 2021-03-01 00:00:00 | 31 | 2021-04-01 00:00:00 | 2021-04-01 00:00:00 | 30 | 2021-05-01 00:00:00 | 2021-05-01 00:00:00 | 31 | 2021-06-01 00:00:00 | 2021-06-01 00:00:00 | 30 | 2021-07-01 00:00:00 | 2021-07-01 00:00:00 | 31 | 2021-08-01 00:00:00 | 2021-08-01 00:00:00 | 31 | 2021-09-01 00:00:00 | 2021-09-01 00:00:00 | 30 | 2021-10-01 00:00:00 | 2021-10-01 00:00:00 | 31 | 2021-11-01 00:00:00 | 2021-11-01 00:00:00 | 30 | 2021-12-01 00:00:00 | 2021-12-01 00:00:00 | 31 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 | 31 | 2022-02-01 00:00:00 | 2022-02-01 00:00:00 | 28 | 2022-03-01 00:00:00 | 2022-03-01 00:00:00 | 31 | 2022-04-01 00:00:00 | 2022-04-01 00:00:00 | 30 | 2022-05-01 00:00:00 | 2022-05-01 00:00:00 | 31 | 2022-06-01 00:00:00 | 2022-06-01 00:00:00 | 30 | 2022-07-01 00:00:00 | 2022-07-01 00:00:00 | 31 | 2022-08-01 00:00:00 | 2022-08-01 00:00:00 | 31 | 2022-09-01 00:00:00 | 2022-09-01 00:00:00 | 30 | 2022-10-01 00:00:00 | 2022-10-01 00:00:00 | 31 | 2022-11-01 00:00:00 | 2022-11-01 00:00:00 | 30 | 2022-12-01 00:00:00 | 2022-12-01 00:00:00 | 31 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 31 | 2023-02-01 00:00:00 | 2023-02-01 00:00:00 | 28 | 2023-03-01 00:00:00 | 2023-03-01 00:00:00 | 31 | 2023-04-01 00:00:00 | 2023-04-01 00:00:00 | 30 | 2023-05-01 00:00:00 | 2023-05-01 00:00:00 | 31 | 2023-06-01 00:00:00 | 2023-06-01 00:00:00 | 30 | 2023-07-01 00:00:00 | 2023-07-01 00:00:00 | 31 | 2023-08-01 00:00:00 | 2023-08-01 00:00:00 | 31 | 2023-09-01 00:00:00 | 2023-09-01 00:00:00 | 30 | 2023-10-01 00:00:00 | 2023-10-01 00:00:00 | 31 | TO DATE
393100-584 | 2023-10-06 00:00:00 | [NAME] | USD | 2022-10-06 00:00:00 | 5000 | 1-Year | 0.0651 |  |  | 0.0651 |  | 0 | 0.0649 |  | 0 | 0.0651 |  | 0 | 0.0649 |  | 0 | 0.065 |  | 0 | 0.0649 |  | 0 | 0.0651 |  | 0 | 0.0649 |  | 0 | 0.0651 |  | 0 | 0.0649 |  | 0 | 0.0651 |  | 0 | 0.0649 |  | 0 | 0.06509999999999999 |  | 0 | 0.0649 |  | 0 | 0.06509999999999999 |  | 0 | 0.0649 |  | 0 | 0.06509999999999999 |  | 0 | 0.0649 |  | 0 | 0.06509999999999999 |  | 0 | 0.0649 |  | 0 | 0.06509999999999999 |  | 0 | 0.0649 |  | 0 | 0.06509999999999999 |  | 0 | 0.0649 |  | 23.11506849315068 | 0.065 |  | 26.71232876712329 | 0.065 |  | 27.6027397260274 | 0.065 |  | 27.6027397260274 | 0.065 |  | 24.93150684931507 | 0.065 |  | 27.6027397260274 | 0.065 |  | 26.71232876712329 | 0.065 |  | 27.6027397260274 | 0.065 |  | 26.71232876712329 | 0.065 |  | 27.6027397260274 | 0.065 |  | 27.6027397260274 | 0.065 |  | 26.71232876712329 | 0.065 |  | 4.452054794520548
373100-584 | 2023-10-06 00:00:00 | [NAME] | PKR | 2022-10-06 00:00:00 | 300000 | 1-Year | 0.1051 |  |  | 0.1051 |  | 0 | 0.1051 |  | 0 | 0.1051 |  | 0 | 0.1051 |  | 0 | 0.1051 |  | 0 | 0.1051 |  | 0 | 0.1051 |  | 0 | 0.1051 |  | 0 | 0.1051 |  | 0 | 0.1051 |  | 0 | 0.1051 |  | 0 | 0.1051 |  | 0 | 0.1051 |  | 0 | 0.1051 |  | 0 | 0.1051 |  | 0 | 0.1051 |  | 0 | 0.1051 |  | 0 | 0.1051 |  | 0 | 0.1051 |  | 0 | 0.1051 |  | 0 | 0.1051 |  | 0 | 0.1051 |  | 0 | 0.1051 |  | 0 | 0.1549 |  | 3310.191780821918 | 0.1551 |  | 3824.383561643835 | 0.155 |  | 3949.315068493151 | 0.155 |  | 3949.315068493151 | 0.155 |  | 3567.123287671233 | 0.155 |  | 3949.315068493151 | 0.155 |  | 3821.917808219178 | 0.155 |  | 3949.315068493151 | 0.155 |  | 3821.917808219178 | 0.155 |  | 3949.315068493151 | 0.155 |  | 3949.315068493151 | 0.155 |  | 3821.917808219178 | 0.155 |  | 636.986301369863
393100-584 | 2023-10-06 00:00:00 | [NAME] | GBP | 2022-10-06 00:00:00 | 5000 | 1-Year | 0.0651 |  |  | 0.0651 |  | 0 | 0.0649 |  | 0 | 0.0651 |  | 0 | 0.0649 |  | 0 | 0.065 |  | 0 | 0.0649 |  | 0 | 0.0651 |  | 0 | 0.0649 |  | 0 | 0.0651 |  | 0 | 0.0649 |  | 0 | 0.0651 |  | 0 | 0.0649 |  | 0 | 0.06509999999999999 |  | 0 | 0.0649 |  | 0 | 0.06509999999999999 |  | 0 | 0.0649 |  | 0 | 0.06509999999999999 |  | 0 | 0.0649 |  | 0 | 0.06509999999999999 |  | 0 | 0.0649 |  | 0 | 0.06509999999999999 |  | 0 | 0.0649 |  | 0 | 0.06509999999999999 |  | 0 | 0.0649 |  | 23.11506849315068 | 0.065 |  | 26.71232876712329 | 0.065 |  | 27.6027397260274 | 0.065 |  | 27.6027397260274 | 0.065 |  | 24.93150684931507 | 0.065 |  | 27.6027397260274 | 0.065 |  | 26.71232876712329 | 0.065 |  | 27.6027397260274 | 0.065 |  | 26.71232876712329 | 0.065 |  | 27.6027397260274 | 0.065 |  | 27.6027397260274 | 0.065 |  | 26.71232876712329 | 0.065 |  | 4.452054794520548
393100-585 | 2023-10-07 00:00:00 | [NAME] | EUR | 2022-10-07 00:00:00 | 9000 | 1-Year | 0.0651 |  |  | 0.0651 |  | 0 | 0.0649 |  | 0 | 0.0651 |  | 0 | 0.0649 |  | 0 | 0.065 |  | 0 | 0.0649 |  | 0 | 0.0651 |  | 0 | 0.0649 |  | 0 | 0.0651 |  | 0 | 0.0649 |  | 0 | 0.0651 |  | 0 | 0.0649 |  | 0 | 0.06509999999999999 |  | 0 | 0.0649 |  | 0 | 0.06509999999999999 |  | 0 | 0.0649 |  | 0 | 0.06509999999999999 |  | 0 | 0.0649 |  | 0 | 0.06509999999999999 |  | 0 | 0.0649 |  | 0 | 0.06509999999999999 |  | 0 | 0.0649 |  | 0 | 0.06509999999999999 |  | 0 | 0.0649 |  | 40.00684931506849 | 0.065 |  | 48.08219178082192 | 0.065 |  | 49.68493150684932 | 0.065 |  | 49.68493150684932 | 0.065 |  | 44.87671232876713 | 0.065 |  | 49.68493150684932 | 0.065 |  | 48.08219178082192 | 0.065 |  | 49.68493150684932 | 0.065 |  | 48.08219178082192 | 0.065 |  | 49.68493150684932 | 0.065 |  | 49.68493150684932 | 0.065 |  | 48.08219178082192 | 0.065 |  | 9.616438356164384
393100-585 | 2023-10-07 00:00:00 | Natasha | USD | 2022-10-07 00:00:00 | 5000 | 1-Year | 0.0651 |  |  | 0.0651 |  | 0 | 0.0649 |  | 0 | 0.0651 |  | 0 | 0.0649 |  | 0 | 0.065 |  | 0 | 0.0649 |  | 0 | 0.0651 |  | 0 | 0.0649 |  | 0 | 0.0651 |  | 0 | 0.0649 |  | 0 | 0.0651 |  | 0 | 0.0649 |  | 0 | 0.06509999999999999 |  | 0 | 0.0649 |  | 0 | 0.06509999999999999 |  | 0 | 0.0649 |  | 0 | 0.06509999999999999 |  | 0 | 0.0649 |  | 0 | 0.06509999999999999 |  | 0 | 0.0649 |  | 0 | 0.06509999999999999 |  | 0 | 0.0649 |  | 0 | 0.06509999999999999 |  | 0 | 0.0649 |  | 22.22602739726027 | 0.065 |  | 26.71232876712329 | 0.065 |  | 27.6027397260274 | 0.065 |  | 27.6027397260274 | 0.065 |  | 24.93150684931507 | 0.065 |  | 27.6027397260274 | 0.065 |  | 26.71232876712329 | 0.065 |  | 27.6027397260274 | 0.065 |  | 26.71232876712329 | 0.065 |  | 27.6027397260274 | 0.065 |  | 27.6027397260274 | 0.065 |  | 26.71232876712329 | 0.065 |  | 5.342465753424658