Spreadsheet: 826921d1682371259-searching-cell-for-multiple-criteria-existing-searching-sample-workbook
Sheet: Raw Ticket Data

Incident Number | Priority | Status | Description | Submit Date | Last Modified Date | Last Resolved Date | Closed Date | Report Data |  | Desired Result
300001234567 | Medium | Cancelled | App2|Calls getting Rejected due to missing Special number Prefix. | 2023-01-12 10:07:06 | 2023-01-31 20:45:08 | 2023-01-31 20:45:05 | 2023-01-31 20:45:05
300001234568 | Medium | Closed | App2|Prefixes missing in number analysis table | 2023-01-12 15:20:06 | 2023-03-28 02:00:02 | 2023-03-24 08:50:05 | 2023-03-28 02:00:00
300001234569 | Medium | Closed | App2 Production machine unreachable prtcarla67 | 2023-01-12 14:05:06 | 2023-02-05 02:02:25 | 2023-02-01 08:56:16 | 2023-02-05 02:00:00
300001234570 | Medium | Closed | App1: NETWORK: NONRAN : App1 : Calling issues | 2023-01-13 16:29:49 | 2023-02-18 14:15:30 | 2023-02-18 14:15:25 | 2023-02-18 14:15:29
300001234571 | Medium | Closed | App1 : Amdocs : Issue : SIM not registered on the network | 2023-01-13 10:50:35 | 2023-02-11 02:02:37 | 2023-02-07 14:03:02 | 2023-02-11 02:00:00
300001234572 | Medium | Closed | App1 : Ports stuck at switch initiated | 2023-01-13 11:12:26 | 2023-02-18 12:22:07 | 2023-02-18 12:21:57 | 2023-02-18 12:22:06
300001234573 | Medium | Closed | App1: ordered sim cards not able to view... | 2023-01-13 12:29:32 | 2023-02-22 02:00:29 | 2023-02-18 13:01:58 | 2023-02-22 02:00:00
300001234574 | Medium | Closed | App2: Temporary Waiver's not populating Interaction Notes when expiring automatically | 2023-01-13 14:05:28 | 2023-02-14 09:21:29 | 2023-02-14 09:21:28 | 2023-02-14 09:21:28
300001234575 | Medium | Closed | App1 : Port-in error | 2023-01-13 14:01:48 | 2023-02-22 02:00:29 | 2023-02-18 15:47:03 | 2023-02-22 02:00:00
300001234576 | Medium | Closed | App1 : [NAME] at sent | 2023-01-14 12:44:51 | 2023-02-22 02:00:30 | 2023-02-18 15:44:28 | 2023-02-22 02:00:00
300001234577 | Medium | Closed | App1 :  Call Coverage issue after Porting | 2023-01-14 18:26:05 | 2023-02-18 19:59:33 | 2023-02-18 19:59:24 | 2023-02-18 19:59:32
300001234578 | Medium | Closed | App1 : Product Issue | 2023-01-13 16:14:04 | 2023-02-18 19:57:41 | 2023-02-18 19:57:31 | 2023-02-18 19:57:41
300001234579 | Medium | Closed | App1 :  International calling | 2023-01-13 19:18:04 | 2023-02-20 02:00:17 | 2023-02-16 12:06:29 | 2023-02-20 02:00:00
300001234580 | Medium | Closed | App1 : CRM : Unable to login | 2023-01-14 14:30:44 | 2023-02-22 02:00:31 | 2023-02-18 13:19:11 | 2023-02-22 02:00:00
300001234581 | Medium | Closed | App1 : NETWORK : RAN : App1 Service Issue | 2023-01-14 17:05:26 | 2023-04-06 10:08:47 | 2023-04-06 10:03:48 | 2023-04-06 10:08:42
300001234582 | Medium | Closed | App1 & App2: Metric "COUNTER" changed status from "good" to "error" | 2023-01-16 02:31:06 | 2023-02-10 02:00:08 | 2023-02-06 08:02:39 | 2023-02-10 02:00:00 |  |  | Rep3
300001234583 | Medium | Closed | App1 : Unable to send or receive text messages after port in | 2023-01-16 12:11:40 | 2023-02-15 16:00:20 | 2023-02-15 16:00:02 | 2023-02-15 16:00:20
300001234584 | Medium | Closed | App1 & App2: Metric "NUM_OF_EXPIRED_EVENTS" changed status from "good" to "error" | 2023-01-16 02:26:06 | 2023-02-10 02:00:10 | 2023-02-06 08:05:01 | 2023-02-10 02:00:00 |  |  | Rep3