Spreadsheet: 776898d1649966065-unique-count-of-values-based-on-corresponding-id-and-if-statement-with-similar-condition-test23
Sheet: Sheet1

Serial number | Type | Status | ID | Name |  |  |  |  | Issue Date | [NAME] | Active & Valid Per Row | [NAME] (90/30/14/7) Per Row |  | [NAME] (90) Per Row |  |  |  |  | Formula 1 | Formula 2 | Formula 3 | Formula 4
8304013772222700 | OT | ISSUED | 568154112108 | ABC |  |  |  |  | 2019-11-13 10:50:16.517000 | 2021-11-13 10:49:36 |  |  |  |  |  |  |  |  | 1 | 0 | Valid | Valid
8304013772222700 | OT | ISSUED | 568154112108 | ABC |  |  |  |  | 2019-11-13 10:50:16.517000 | 2021-11-13 10:49:36 |  |  |  |  |  |  |  |  | 1 | 0 | Valid | Valid
8336013926733800 | OT | ISSUED | 568154112108 | ABC |  |  |  |  | 2021-11-12 08:38:27.067000 | 2023-11-12 08:38:03 |  |  |  |  |  |  |  |  | 1 | 0 | Valid | Valid
8336013926733800 | OT | ISSUED | 568154112108 | ABC |  |  |  |  | 2021-11-12 08:38:27.067000 | 2023-11-12 08:38:03 |  |  |  |  |  |  |  |  | 1 | 0 | Valid | Valid
3130002954967539 | GJC4 | RENEWED | 561448899106 | DEF |  |  |  |  | 2021-03-18 08:52:42.377000 | 2023-03-18 08:53:48 |  |  |  |  |  |  |  |  | 1 | 0 | Valid | Valid
3130002954967539 | GJC4 | RENEWED | 561448899106 | DEF |  |  |  |  | 2021-03-18 08:52:42.377000 | 2023-03-18 08:53:48 |  |  |  |  |  |  |  |  | 1 | 0 | Valid | Valid
5121000063401700 | OT | ISSUED | 559371321100 | MNO |  |  |  |  | 2016-08-03 11:57:20.592000 | 2018-08-03 11:56:30 |  |  |  |  |  |  |  |  | 0 |  |  | Expired
8328014380747500 | OT | ISSUED | 578954125102 | XYZ |  |  |  |  | 2021-05-14 09:25:41.589000 | 2023-05-14 09:28:35 |  |  |  |  |  |  |  |  | 3 | 0 | Valid | Valid
9192018767647000 | OT | ISSUED | 578954125102 | XYZ |  |  |  |  | 2021-05-11 11:49:02.403000 | 2023-05-11 11:51:58 |  |  |  |  |  |  |  |  | 3 | 0 | Valid | Valid
9192018767627000 | OT | ISSUED | 578954125102 | XYZ |  |  |  |  | 2021-05-13 09:37:03.773000 | 2023-05-13 09:40:02 |  |  |  |  |  |  |  |  | 3 | 0 | Valid | Valid
2015015612958124 | GJC4 | ISSUED | 561874035104 | TQR |  |  |  |  | 2017-08-09 11:14:57.501000 | 2019-08-09 11:14:33 |  |  |  |  |  |  |  |  | 0 |  |  | Expired
5124000698204900 | OT | ISSUED | 511194763047 | HIJ |  |  |  |  | 2018-11-07 15:57:21.188000 | 2020-11-07 15:56:50 |  |  |  |  |  |  |  |  | 0 |  |  | Expired
5121000063361700 | OT | ISSUED | 77404689042 | ATK |  |  |  |  | 2016-04-06 10:21:42.975000 | 2018-04-06 10:20:51 |  |  |  |  |  |  |  |  | 2 | 1 | Valid | Valid
6011003631622200 | OT | ISSUED | 77404689042 | ATK |  |  |  |  | 2017-09-12 09:35:44.721000 | 2019-09-12 09:35:30 |  |  |  |  |  |  |  |  | 2 | 1 | Valid | Valid
7052015581911306 | GJC | RENEWED | 77404689042 | ATK |  |  |  |  | 2019-06-11 10:14:33.069000 | 2021-06-11 10:12:51 |  |  |  |  |  |  |  |  | 2 | 1 | Valid | Valid
6356011031910986 | GJC4 | RENEWED | 77404689042 | ATK |  |  |  |  | 2021-06-10 09:33:32.081000 | 2023-06-10 09:35:53 |  |  |  |  |  |  |  |  | 2 | 1 | Valid | Valid
6356011003910986 | GJC4 | ISSUED | 77404689042 | ATK |  |  |  |  | 2018-07-17 10:29:53.584000 | 2020-07-17 10:29:32 |  |  |  |  |  |  |  |  | 2 | 1 | Valid | Valid
9192018579617000 | OT | ISSUED | 77404689042 | ATK |  |  |  |  | 2020-08-21 12:32:16.003000 | 2022-06-27 14:09:07 |  |  |  |  |  |  |  |  | 2 | 1 | Valid | Valid
8304013772652700 | OT | ISSUED | 576264555107 | DAT |  |  |  |  | 2020-05-12 16:31:49.993000 | 2022-05-12 16:31:28 |  |  |  |  |  |  |  |  | 1 | 1 | Valid | 30 Days
8304013772652700 | OT | ISSUED | 576264555107 | DAT |  |  |  |  | 2020-05-12 16:31:49.993000 | 2022-05-12 16:31:28 |  |  |  |  |  |  |  |  | 1 | 1 | Valid | 30 Days
0338027216009800 | OT | ISSUED | 425887123569 | ATT |  |  |  |  | 2022-03-30 11:16:36.074000 | 2024-03-30 10:16:15 |  |  |  |  |  |  |  |  | 1 | 0 | Valid | Valid
6195024313910086 | GJC | EXPIRED | 425887123569 | ATT |  |  |  |  | 2015-01-20 17:36:09 | 2017-01-20 17:36:09 |  |  |  |  |  |  |  |  | 1 | 0 | Valid | Valid
3119018123967345 | GJC | CANCELLED | 425887123569 | ATT |  |  |  |  | 2021-10-05 08:41:40.503000 | 2023-10-05 08:40:18 |  |  |  |  |  |  |  |  | 1 | 0 | Valid | Valid
8336014366943800 | OT | ISSUED | 576790589103 | ATB |  |  |  |  | 2020-07-29 13:48:55.547000 | 2022-06-27 14:09:07 |  |  |  |  |  |  |  |  | 1 | 1 | Valid | 90 Days
4082C2040A282820 | GJC | RENEWED | 638386774563 | AVN |  |  |  |  | 2022-03-31 18:01:18.682000 | 2024-03-31 18:00:37 |  |  |  |  |  |  |  |  | 2 | 0 | Valid | Valid
4082C2040A282820 | GJC | RENEWED | 638386774563 | AVN |  |  |  |  | 2022-03-31 18:01:18.682000 | 2024-03-31 18:00:37 |  |  |  |  |  |  |  |  | 2 | 0 | Valid | Valid
7052033291911306 | GJC | RENEWED | 638386774563 | AVN |  |  |  |  | 2020-11-04 20:14:50.314000 | 2022-11-04 20:12:51 |  |  |  |  |  |  |  |  | 2 | 0 | Valid | Valid
7052033291911306 | GJC | RENEWED | 638386774563 | AVN |  |  |  |  | 2020-11-04 20:14:50.314000 | 2022-11-04 20:12:51 |  |  |  |  |  |  |  |  | 2 | 0 | Valid | Valid