Hello I am new member. My name is Jolly
For audit purposes, I need to select 3 notes per physician from a database (see attached excel sheet). They are namely Discharge Summary, Progress Notes, History and Physical from different dates.
Currently I am using the If function and assigning values for each note type. Then using the pivot table randomly pick 3 notes. Please see excel sheet Alex brit.
I am sure there is an easier way. Awaiting your advice and help.
For audit purposes, I need to select 3 notes per physician from a database (see attached excel sheet). They are namely Discharge Summary, Progress Notes, History and Physical from different dates.
Currently I am using the If function and assigning values for each note type. Then using the pivot table randomly pick 3 notes. Please see excel sheet Alex brit.
I am sure there is an easier way. Awaiting your advice and help.