Spreadsheet: 889211d1739949270-i-want-to-pull-out-data-through-any-excel-function-excel-problem-19-02-2025
Sheet: Sheet1

Operation | Security Code | Maturity Date | Name of Customer | Currency | Issue Date | Investment  Amount | Tenure
Maturity | [PHONE] | 2025-02-11 00:00:00 | [NAME] | USD | 2024-11-13 00:00:00 | 3000 | 6-Months
Maturity | [PHONE] | 2025-02-11 00:00:00 | [NAME] | EUR | 2024-11-13 00:00:00 | 3500000 | 3-Months
Maturity | [PHONE] | 2025-02-11 00:00:00 | [NAME] | EUR | 2024-11-13 00:00:00 | 160000 | 1-Year
Maturity | [PHONE] | 2025-02-11 00:00:00 | [NAME] | [NAME] | 2024-11-13 00:00:00 | 1300000 | 3-Months
Maturity | [PHONE] | 2025-02-11 00:00:00 | [NAME] | USD | 2024-08-15 00:00:00 | 15000 | 3-Months
Maturity | [PHONE] | 2025-02-11 00:00:00 | [NAME] | [NAME] | 2024-11-13 00:00:00 | 210000 | 3-Months
Maturity | [PHONE] | 2025-02-12 00:00:00 | [NAME] | [NAME] | 2024-08-16 00:00:00 | 1300000 | 3-Months
Maturity | [PHONE] | 2025-02-12 00:00:00 | [NAME] | [NAME] | 2024-11-14 00:00:00 | 450000 | 3-Months
Maturity | [PHONE] | 2025-02-12 00:00:00 | [NAME] | [NAME] | 2024-02-12 00:00:00 | 34000 | 1-Year
Maturity | [PHONE] | 2025-02-12 00:00:00 | [NAME] | [NAME] | 2024-11-14 00:00:00 | 100000 | 1-Year
Maturity | [PHONE] | 2025-02-12 00:00:00 | [NAME] | USD | 2024-11-14 00:00:00 | 40000 | 3-Months
Maturity | [PHONE] | 2025-02-12 00:00:00 | [NAME] | SAR | 2024-11-14 00:00:00 | 300000 | 3-Months
Maturity | [PHONE] | 2025-02-12 00:00:00 | [NAME] | SAR | 2024-11-14 00:00:00 | 1000000 | 6-Months
Maturity | [PHONE] | 2025-02-12 00:00:00 | Betty | SAR | 2024-11-14 00:00:00 | 56000 | 3-Months
Maturity | [PHONE] | 2025-02-12 00:00:00 | Sandra | SAR | 2024-02-12 00:00:00 | 220000 | 3-Months
Maturity | [PHONE] | 2025-02-12 00:00:00 | Amelia | SAR | 2024-02-12 00:00:00 | 325000 | 3-Months
Maturity | [PHONE] | 2025-02-12 00:00:00 | Isla | USD | 2024-11-14 00:00:00 | 9000 | 3-Months
Maturity | [PHONE] | 2025-02-12 00:00:00 | Ava | GBP | 2024-11-14 00:00:00 | 7000000 | 3-Months
Maturity | [PHONE] | 2025-02-12 00:00:00 | Lily | GBP | 2024-08-16 00:00:00 | 1000000 | 3-Months
Maturity | [PHONE] | 2025-02-12 00:00:00 | [NAME] | GBP | 2024-11-14 00:00:00 | 8600000 | 3-Months
Maturity | [PHONE] | 2025-02-12 00:00:00 | [NAME] | USD | 2024-11-14 00:00:00 | 19000 | 3-Months
Maturity | [PHONE] | 2025-02-13 00:00:00 | George | EUR | 2024-11-15 00:00:00 | 1125000 | 1-Year
Maturity | [PHONE] | 2025-02-13 00:00:00 | Leo | EUR | 2024-11-15 00:00:00 | 500000 | 3-Months
Maturity | [PHONE] | 2025-02-13 00:00:00 | [NAME] | USD | 2024-11-15 00:00:00 | 5000 | 1-Year
Maturity | [PHONE] | 2025-02-13 00:00:00 | [NAME] | USD | 2024-11-15 00:00:00 | 1500 | 3-Months
Maturity | [PHONE] | 2025-02-13 00:00:00 | [NAME] | USD | 2024-11-15 00:00:00 | 30000 | 1-Year
Maturity | [PHONE] | 2025-02-13 00:00:00 | [NAME] | AED | 2024-11-15 00:00:00 | 700000 | 3-Months
Maturity | [PHONE] | 2025-02-13 00:00:00 | [NAME] | AED | 2024-02-13 00:00:00 | 700000 | 3-Months
Maturity | [PHONE] | 2025-02-13 00:00:00 | [NAME] | USD | 2024-11-15 00:00:00 | 500000 | 3-Months
Maturity | [PHONE] | 2025-02-13 00:00:00 | [NAME] | SAR | 2024-02-13 00:00:00 | 1000000 | 3-Months
Maturity | [PHONE] | 2025-02-13 00:00:00 | Jessica | SAR | 2024-11-15 00:00:00 | 1000000 | 3-Months
Maturity | [PHONE] | 2025-02-13 00:00:00 | [NAME] | SAR | 2024-02-13 00:00:00 | 6590000 | 3-Months
Maturity | [PHONE] | 2025-02-13 00:00:00 | [NAME] | SAR | 2024-11-15 00:00:00 | 20000000 | 3-Months
Maturity | [PHONE] | 2025-02-13 00:00:00 | [NAME] | SAR | 2024-11-15 00:00:00 | 3160000 | 3-Months
Maturity | [PHONE] | 2025-02-13 00:00:00 | [NAME] | SAR | 2024-11-15 00:00:00 | 1000000 | 3-Months
Maturity | [PHONE] | 2025-02-13 00:00:00 | [NAME] | USD | 2024-11-15 00:00:00 | 1000000 | 3-Months
Maturity | [PHONE] | 2025-02-13 00:00:00 | [NAME] | EUR | 2024-11-15 00:00:00 | 2610000 | 3-Months
Maturity | [PHONE] | 2025-02-13 00:00:00 | [NAME] | USD | 2024-11-15 00:00:00 | 5000 | 3-Months
Maturity | [PHONE] | 2025-02-13 00:00:00 | [NAME] | GBP | 2024-11-15 00:00:00 | 2500000 | 3-Months
Maturity | [PHONE] | 2025-02-13 00:00:00 | [NAME] | GBP | 2024-11-15 00:00:00 | 27000 | 3-Months
Maturity | [PHONE] | 2025-02-13 00:00:00 | [NAME] | GBP | 2024-11-15 00:00:00 | 5000000 | 3-Months
Maturity | [PHONE] | 2025-02-13 00:00:00 | [NAME] | GBP | 2024-11-15 00:00:00 | 5000 | 1-Year
Maturity | [PHONE] | 2025-02-13 00:00:00 | [NAME] | USD | 2024-11-15 00:00:00 | 5000 | 1-Year
Maturity | [PHONE] | 2025-02-13 00:00:00 | [NAME] | AED | 2024-11-15 00:00:00 | 1000000 | 1-Year
Maturity | [PHONE] | 2025-02-13 00:00:00 | [NAME] | USD | 2024-11-15 00:00:00 | 6000 | 1-Year
Maturity | [PHONE] | 2025-02-13 00:00:00 | [NAME] | EUR | 2024-11-15 00:00:00 | 1000 | 3-Months
Maturity | [PHONE] | 2025-02-13 00:00:00 | Stephen | USD | 2024-11-15 00:00:00 | 1439000 | 1-Year
Maturity | [PHONE] | 2025-02-14 00:00:00 | Justin | GBP | 2024-02-14 00:00:00 | 1000000 | 3-Months
Maturity | [PHONE] | 2025-02-14 00:00:00 | [NAME] | SAR | 2024-02-14 00:00:00 | 195000 | 1-Year
Maturity | [PHONE] | 2025-02-14 00:00:00 | [NAME] | AED | 2024-02-14 00:00:00 | 20000 | 6-Months
Maturity | [PHONE] | 2025-02-14 00:00:00 | [NAME] | SAR | 2024-02-14 00:00:00 | 910000 | 6-Months
Maturity | [PHONE] | 2025-02-15 00:00:00 | Jhon | AED | 2024-02-15 00:00:00 | 980000 | 1-Year
Maturity | [PHONE] | 2025-02-15 00:00:00 | Marshell | USD | 2024-08-19 00:00:00 | 10000 | 6-Months
Maturity | [PHONE] | 2025-02-15 00:00:00 | Bhoomia | AED | 2024-02-15 00:00:00 | 200000 | 1-Year
Maturity | [PHONE] | 2025-02-15 00:00:00 | [NAME] | AED | 2024-02-15 00:00:00 | 200000 | 1-Year
Maturity | [PHONE] | 2025-02-15 00:00:00 | [NAME] | AED | 2024-02-15 00:00:00 | 100000 | 1-Year
Maturity | [PHONE] | 2025-02-15 00:00:00 | [NAME] | GBP | 2024-08-19 00:00:00 | 139000 | 6-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | [NAME] | USD | 2024-11-18 00:00:00 | 25000 | 3-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | Stone | USD | 2024-11-18 00:00:00 | 200000 | 3-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | [NAME] | SAR | 2024-11-18 00:00:00 | 100000 | 3-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | [NAME] | SAR | 2024-11-18 00:00:00 | 1500000 | 3-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | [NAME] | SAR | 2024-11-18 00:00:00 | 8500000 | 3-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | Almatay | SAR | 2024-11-18 00:00:00 | 3750000 | 3-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | [NAME] | SAR | 2024-11-18 00:00:00 | 13690000 | 3-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | Shams | SAR | 2024-11-18 00:00:00 | 50000 | 3-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | Wazaaay | SAR | 2024-11-18 00:00:00 | 550000 | 3-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | [NAME] | SAR | 2024-11-18 00:00:00 | 415000 | 3-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | Michel | SAR | 2024-08-20 00:00:00 | 2000000 | 6-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | Jhon | SAR | 2024-08-20 00:00:00 | 1800000 | 6-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | Marshell | SAR | 2024-08-20 00:00:00 | 200000 | 6-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | Bhoomia | SAR | 2024-08-20 00:00:00 | 200000 | 6-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | [NAME] | [NAME] | 2024-11-18 00:00:00 | 10000 | 3-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | [NAME] | [NAME] | 2024-11-18 00:00:00 | 10000 | 3-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | [NAME] | [NAME] | 2024-11-18 00:00:00 | 10000 | 3-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | [NAME] | [NAME] | 2024-11-18 00:00:00 | 2000000 | 3-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | Stone | [NAME] | 2024-02-16 00:00:00 | 2100000 | 1-Year
Maturity | [PHONE] | 2025-02-16 00:00:00 | [NAME] | GBP | 2024-11-18 00:00:00 | 13000 | 3-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | [NAME] | EUR | 2024-11-18 00:00:00 | 100000 | 3-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | [NAME] | EUR | 2024-11-18 00:00:00 | 5000000 | 3-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | Almatay | EUR | 2024-11-18 00:00:00 | 152000 | 3-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | [NAME] | EUR | 2024-11-18 00:00:00 | 4600000 | 3-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | Shams | EUR | 2024-11-18 00:00:00 | 1500000 | 3-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | Wazaaay | USD | 2024-11-18 00:00:00 | 8000 | 3-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | [NAME] | SAR | 2024-08-20 00:00:00 | 1000000 | 6-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | Michel | SAR | 2024-11-18 00:00:00 | 138000 | 3-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | FAHAD MAQSOOD | SAR | 2024-11-18 00:00:00 | 4160000 | 3-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | NOOR UL ISLAM NOORI | GBP | 2024-11-18 00:00:00 | 891000 | 3-Months
Maturity | [PHONE] | 2025-02-16 00:00:00 | IMRAN QAZI | GBP | 2024-11-18 00:00:00 | 950000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | MANOHAR | USD | 2024-11-19 00:00:00 | 5000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | Mathew | AED | 2024-11-19 00:00:00 | 105000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | Jhon | USD | 2024-08-21 00:00:00 | 1000000 | 6-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | Marshell | USD | 2024-08-21 00:00:00 | 324000 | 6-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | Bhoomia | AED | 2024-11-19 00:00:00 | 1750000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | [NAME] | AED | 2024-11-19 00:00:00 | 2355000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | [NAME] | AED | 2024-11-19 00:00:00 | 6500000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | [NAME] | AED | 2024-11-19 00:00:00 | 850000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | [NAME] | AED | 2024-11-19 00:00:00 | 1000000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | Stone | AED | 2024-11-19 00:00:00 | 1000000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | [NAME] | AED | 2024-11-19 00:00:00 | 650000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | [NAME] | AED | 2024-11-19 00:00:00 | 1000000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | [NAME] | AED | 2024-11-19 00:00:00 | 829000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | Almatay | AED | 2024-11-19 00:00:00 | 3700000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | [NAME] | AED | 2024-11-19 00:00:00 | 500000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | Shams | AED | 2024-11-19 00:00:00 | 32000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | Wazaaay | AED | 2024-11-19 00:00:00 | 1450000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | [NAME] | AED | 2024-11-19 00:00:00 | 181457000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | Michel | AED | 2024-11-19 00:00:00 | 2780000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | [NAME] | AED | 2024-11-19 00:00:00 | 3300000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | [NAME] | AED | 2024-11-19 00:00:00 | 80000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | [NAME] | AED | 2024-11-19 00:00:00 | 380000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | [NAME] | AED | 2024-11-19 00:00:00 | 950000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | WASIM NAWAZ | USD | 2024-11-19 00:00:00 | 13000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | ABU GHARAB | SAR | 2024-11-19 00:00:00 | 530000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | WASIM NAWAZ | SAR | 2024-11-19 00:00:00 | 1050000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | [NAME] | USD | 2024-08-21 00:00:00 | 88000 | 6-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | Pintock | GBP | 2024-11-19 00:00:00 | 1100000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | Giovineee | GBP | 2024-11-19 00:00:00 | 2204000 | 3-Months
Maturity | [PHONE] | 2025-02-17 00:00:00 | Krystal | USD | 2024-11-19 00:00:00 | 178000 | 3-Months
 |  |  |  |  |  |  |  |  |  | USD
 |  |  |  | Date of Report | Currency List |  |  |  |  | GBP
 |  |  |  | 2025-02-11 00:00:00 | SAR |  |  |  |  | EUR
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | SAR
 | Security Code # | Security Maturity Date | Security Issuance Date | Tenure of Investment | Amount of Investment |  |  |  |  | AED
 | A | B | C | D | E
1 | [PHONE] | 2025-02-12 00:00:00
 | [PHONE] | 2025-02-12 00:00:00
 | [PHONE] | 2025-02-12 00:00:00
 | [PHONE] | 2025-02-12 00:00:00
 | [PHONE] | 2025-02-12 00:00:00
 | [PHONE] | 2025-02-12 00:00:00
 | [PHONE] | 2025-02-12 00:00:00
 | [PHONE] | 2025-02-12 00:00:00
 | [PHONE] | 2025-02-12 00:00:00
 | [PHONE] | 2025-02-12 00:00:00
First thanks for creating such a beneficial platform for excel related issues without cost and valuable solutions. I would like to request for help from you people.
I need to make finer & tune attached excel problem wherein:
I want to make a report in excel on attached format. Therefore, I want to get each security code on a specific/reporting date (not to repeat security code) and respective maturity date with help of formula in attached table. I have applied excel formulas on Issuance date, Tenure and total sum of Investment.
Now I want to get below data through any excel function:
Ø  Each security codes on a specific reporting date (not to repeat security code).
Ø  Maturity date against each security codes on a specific reporting date.