Spreadsheet: 848944d1699540584-i-want-to-pull-out-extract-data-through-excel-formula-excel-solution-request1
Sheet: Sheet1

S.No. | Customer Name | Investment Date | Currency | Investment Amount | Issue Date | 1st Coupon | 2nd Coupon | 3rd Coupon | 4th Coupon | 5th Coupon | 6th Coupon | 7th Coupon | 8th Coupon | 9th Coupon | 10th Coupon | Maturity Date | Coupon Date | Tenor | Certificate # | GL Number | Status | BANK A/C Number | Classification
1 | [NAME] | 2020-10-26 00:00:00 | GBP | 1000000 | 2021-10-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 1-Year | 373000-002 | S-00101-000003440 |  | 3341413000000493 | NON-RESIDENT
 | Sophia | 2020-10-26 00:00:00 | EUR | 500000 | 2022-01-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 3-Months | 371000-002 | S-00101-000003439 |  | 3387413000000550 | NON-RESIDENT
 | [NAME] | 2020-10-26 00:00:00 | AED | 100000 | 2020-11-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 5-Years | 375000-002 | S-00101-000003278 |  | 3228413000000835 | NON-RESIDENT
 | [NAME] | 2020-10-26 00:00:00 | USD | 5000 | 2021-10-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 1-Year | 393000-002 | S-00101-000003644 |  | 3098414000003822 | NON-RESIDENT
 | [NAME] | 2020-10-27 00:00:00 | SAR | 100000 | 2023-02-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 3-Years | 375000-003 | S-00101-000003406 |  | 3228413000001400 | NON-RESIDENT
 | Emma | 2020-10-27 00:00:00 | USD | 100000 | 2023-05-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 3-Months | 371000-003 | S-00101-000003451 |  | 8341413000000009 | NON-RESIDENT
 | [NAME] | 2020-10-27 00:00:00 | USD | 500000 | 2023-08-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 3-Months | 371000-003 | S-00101-000003452 |  | 3387413000000513 | NON-RESIDENT
 | [NAME] | 2020-10-27 00:00:00 | USD | 5000 | 2020-10-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 5-Years | 395000-003 | S-00101-000003703 |  | 3228414000000834 | NON-RESIDENT
 | Olivia | 2020-10-27 00:00:00 | USD | 5000 | 2022-06-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 3-Years | 395000-003 | S-00101-000003648 |  | 3228414000001108 | NON-RESIDENT
 | [NAME] | 2020-10-28 00:00:00 | EUR | 500000 | 2023-03-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 6-Months | 372000-004 | S-00101-000003444 |  | 3228413000001328 | NON-RESIDENT
 | STATUS |  |  |  | REQUIRED
 | Outstanding | Hold by Customer till Maturity date |  |  | BLANK
 | Matured | Matured at the date of Maturity |  |  | MATURED
 | Pre-Matured | Pre-Matured by Customer before Maturity date |  |  | Pre-Matured
 | CLASSIFICATION
 | Resident
 | Non-Resident
 | Resident & Non-Resident
 | CURRENCY
 | USD |  |  | I have a portfolio of almost 20,000 Customers as mentioned in Excel Sheet. I want to pull out/extract data through [NAME] for the followings:
 | EUR
 | GBP |  |  | 1). How to [NAME] of each customer in Excel Sheet as "Matured", "Pre-Matured" or Blank "Outstanding" with the help of [NAME].
 | AED |  |  | 2). How to [NAME] if any Customer want to avail Pre-Maturity option in the excel sheet with the help of [NAME].
 | SAR |  |  | 3). How to Pull out data of Customers those have become eligible for 6 month Coupon (in the case of 3 years & 5 Years only) with the help of [NAME].
 | TENORS
 | 3-Months | No Coupon
 | 6-Months | No Coupon
 | 1-Year | No Coupon
 | 3-Years | 6 Monthly Coupon
 | 5-Years | 6 Monthly Coupon