abarodi1
New Member
- Joined
- Apr 10, 2023
- Messages
- 1
- Office Version
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Platform
- Windows
- MacOS
- Mobile
Hi,
I'm a healthworker and i relly need your help guys. I have the sample data (please see attached image). The real data consist of thousands of patients but i will give 3 patients only for the benefit of time.
What I want to achieve guys is to show only the row where the recent or last dose of the patient Given 3 patients below
1. Mr. Wick has 1st and 2nd dose so I want to retain only the row 4 where the recent dose of Mr. Wick is 2.
2. Mr. Reeves has 1, 2, and 3 dose so i want to retain only the data on row 7.
3. Mr. Trump has only 1 dose so i want to retain the data of row 8.
I hope you guys can help us. We really need this to monitor our patient's next dose.
God bless and thank you!
I'm a healthworker and i relly need your help guys. I have the sample data (please see attached image). The real data consist of thousands of patients but i will give 3 patients only for the benefit of time.
What I want to achieve guys is to show only the row where the recent or last dose of the patient Given 3 patients below
1. Mr. Wick has 1st and 2nd dose so I want to retain only the row 4 where the recent dose of Mr. Wick is 2.
2. Mr. Reeves has 1, 2, and 3 dose so i want to retain only the data on row 7.
3. Mr. Trump has only 1 dose so i want to retain the data of row 8.
I hope you guys can help us. We really need this to monitor our patient's next dose.
God bless and thank you!