Forum Discussion
Tracking for patients
MarinaSaadalla Thanks! I assume that the Card numbers represent the patients. I created a pivot table that counts the number of visits per card number, per assessment, per day. Showing only those that had more than 1 visit in total. That limits the list to 10 patients, one of which had 3 visits within two days. Up to you to judge the weirdness.
Now, in your real file with 68000 records, you could start in the same way, but vary the filtering limits to limit the output.
Riny_van_Eekelen I found highlighted card numbers in the data sheet, how did you do it ?
- Riny_van_EekelenMay 16, 2021Platinum Contributor
MarinaSaadalla You mean the ones in col F on the Data sheet? I just applied conditional formatting to highlight duplicate card numbers. Can't really remember why I did that, though.
- MarinaSaadallaMay 16, 2021Copper Contributor
Riny_van_Eekelen Thank you .. really I appreciate your help.