Spreadsheet: 889149d1739876629-i-want-to-know-each-security-code-number-on-a-specific-date-excel-query-17-02-2025
Sheet: Sheet1

Operation | Security Code | Maturity Date | Name of Customer | Currency | Issue Date | Investment  Amount | Tenure
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
Security Code # | Security Issuance Date | Tenure of Investment | Amount of Investment
A | B | C | D
First of all, I would like to pay my heartiest thanks for creating such a beneficial platform for excel related issues. I feel pleasure to request for help from you people.
I need to solve attached excel problem wherein:
I want to know amount of total investment of each security code on specific date (not to repeat security code – need sum of below information against one single code) as followings:
1.       How many security codes are there on a specific date (not to repeat).
2.       amount of total investment against each security code Maturity date wise
3.       amount of total investment against each security code Currency wise
4.       amount of total investment against each security code Tenure wise; and
5.       amount of total investment against each security code issue date.