sultanofding
New Member
- Joined
- Feb 11, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello,
I am trying to create a function to look up a subject number and the sum the 'Days on o2' where it the maximum for matched start dates. ie patient 001-001, sum the max where the start date is 11/6/20 (2), 11/5/20 (2), 11/8 (4), 11/11 (2) - 10 in total, essentially to not double count entries with the same start date.
I am trying to create a function to look up a subject number and the sum the 'Days on o2' where it the maximum for matched start dates. ie patient 001-001, sum the max where the start date is 11/6/20 (2), 11/5/20 (2), 11/8 (4), 11/11 (2) - 10 in total, essentially to not double count entries with the same start date.