Spreadsheet: 719174d1613545907-formula-to-filter-the-duplicate-values-and-show-all-records-sample
Sheet: Sheet 2

Patient ID | Date of ER Visit | Registration Time | Calender Days later for triage time | Triage Time | CTAS Level | Calender days later for seen by physican | Physican Exam Time | Calender days later for time of decision | Time of decision | Admission Type | [NAME] | Calender days later for time of disposition | Time of Disposition/ Discharge Time | Returned to ER within 24 hrs
89302744293 | 2020-11-15 00:00:00 | 13:16:00 |  | 13:30:00 | 4 |  | 13:40:00 |  | 14:50:00 |  | Home |  | 14:55:00
89292383441 | 2020-11-01 00:00:00 | 14:25:00 |  | 14:30:00 | 4 |  | 14:35:00 |  | 14:45:00 |  | Home |  | 14:50:00
67375560337 | 2020-11-03 00:00:00 | 10:00:00 |  | 10:05:00 | 4 |  | 10:10:00 |  | 10:20:00 |  | Home |  | 10:25:00
65301266207 | 2020-11-01 00:00:00 | 07:45:00 |  | 08:10:00 | 4 |  | 08:15:00 |  | 08:25:00 |  | Home |  | 08:30:00
11819373532 | 2020-11-02 00:00:00 | 00:22:00 |  | 00:30:00 | 4 |  | 00:40:00 |  | 00:50:00 |  | Home |  | 00:55:00
9559874688 | 2020-11-09 00:00:00 | 00:25:00 |  | 00:30:00 | 4 |  | 00:40:00 |  | 00:50:00 |  | Home |  | 00:55:00
9378176693 | 2020-11-27 00:00:00 | 20:10:00 |  | 20:13:00 | 4 |  | 20:15:00 |  | 20:18:00 |  | Home |  | 20:22:00
9378176693 | 2020-11-29 00:00:00 | 15:36:00 |  | 15:40:00 | 4 |  | 15:50:00 |  | 16:20:00 |  | Home |  | 16:30:00
8812549617 | 2020-11-04 00:00:00 | 02:15:00 |  | 02:30:00 | 3 |  | 02:57:00 |  | 05:34:00 |  | Home |  | 05:39:00
7887742311 | 2020-11-07 00:00:00 | 20:55:00 |  | 21:05:00 | 3 |  | 21:10:00 |  | 22:45:00 |  | Home |  | 22:50:00
7833176698 | 2020-11-27 00:00:00 | 14:59:00 |  | 15:20:00 | 4 |  | 15:25:00 |  | 15:30:00 |  | Home |  | 15:33:00
7753724418 | 2020-11-07 00:00:00 | 07:17:00 |  | 07:20:00 | 4 |  | 07:25:00 |  | 07:30:00 |  | Home |  | 07:35:00
7329575811 | 2020-11-02 00:00:00 | 06:00:00 |  | 06:00:00 | 4 |  | 06:05:00 |  | 06:15:00 |  | Home |  | 06:20:00
6612598721 | 2020-11-02 00:00:00 | 00:40:00 |  | 01:10:00 | 4 |  | 01:25:00 |  | 01:35:00 |  | Home |  | 01:40:00
4477125212 | 2020-11-10 00:00:00 | 14:00:00 |  | 14:10:00 | 4 |  | 14:30:00 |  | 14:35:00 |  | home |  | 14:40:00
1559960503 | 2020-11-25 00:00:00 | 18:59:00 |  | 19:00:00 | 3 |  | 19:16:00 |  | 19:25:00 |  | Home |  | 19:50:00
32204862 | 2020-11-05 00:00:00 | 16:30:00 |  | 16:53:00 | 4 |  | 17:05:00 |  | 17:15:00 |  | Home |  | 17:20:00
29220525 | 2020-11-03 00:00:00 | 18:00:00 |  | 18:05:00 | 4 |  | 18:15:00 |  | 18:25:00 |  | Home |  | 18:30:00
19575875 | 2020-11-05 00:00:00 | 13:00:00 |  | 13:10:00 | 3 |  | 13:15:00 |  | 13:25:00 |  | Home |  | 13:30:00
19575875 | 2020-11-11 00:00:00 | 01:05:00 |  | 01:10:00 | 4 |  | 01:15:00 |  | 01:20:00 |  | home |  | 01:25:00
6748930 | 2020-11-02 00:00:00 | 14:00:00 |  | 14:10:00 | 4 |  | 14:15:00 |  | 14:25:00 |  | Home |  | 14:30:00 |  |  |  | I want when I make a filter by (yes) to show all the patient ID for each patient
6748930 | 2020-11-05 00:00:00 | 00:50:00 |  | 00:55:00 | 4 |  | 01:00:00 |  | 01:05:00 |  | Home |  | 01:10:00 |  |  |  | As shown I have only 1 patient ID for each Patient
6748930 | 2020-11-07 00:00:00 | 15:39:00 |  | 15:45:00 | 3 |  | 16:00:00 |  | 16:30:00 |  | Home |  | 16:35:00
6748930 | 2020-11-08 00:00:00 | 01:30:00 |  | 01:30:00 | 4 |  | 01:40:00 |  | 01:45:00 |  | Home |  | 01:50:00
4368821 | 2020-11-05 00:00:00 | 01:10:00 |  | 01:20:00 | 4 |  | 01:25:00 |  | 01:35:00 |  | Home |  | 01:40:00 |  |  |  | I expect duplicate values for each patient returned to ER within 24 hrs
4368821 | 2020-11-07 00:00:00 | 02:30:00 |  | 02:40:00 | 4 |  | 02:45:00 |  | 02:55:00 |  | Home |  | 03:00:00
397573 | 2020-11-04 00:00:00 | 06:50:00 |  | 06:55:00 | 4 |  | 07:00:00 |  | 07:10:00 |  | Home |  | 07:15:00
123456 | 2020-11-09 00:00:00 | 16:27:00 |  | 16:27:00 | 4 |  | 16:30:00 |  | 16:40:00 |  | Home |  | 16:45:00
123456 | 2020-11-11 00:00:00 | 11:20:00 |  | 11:25:00 | 4 |  | 11:30:00 |  | 11:35:00 |  | home |  | 11:40:00