Trying to sort training records within a pivot table. For each Procedure being trained an employee potentially could be trained on multiple revisions of the procedure. All would be documented by the revision level being trained on and the date of training. What I want to show in a pivot table is only the highest revision level trained.
Example with fictitious names.
John Smith trained on SOP 7.5.501 revision levels 1 through 6. Would like his record to show only Rev 6
Jackalynn Brown trained on SOP 7.5.500 revision levels 1 through 3. Would like her record to show only Rev 3
Of course the rest of the employees would be listed similarly with only the highest Rev level trained shown. Struggling a bit with filters, etc. My skill level to date has not been in writing script, etc.
Any help would be appreciated. File attached.
Dennis
Bookmarks