Getting the count of keywords in each for each employee

I have an excel sheet that contains the attendance of each employees.
I need to read each employee name and should count the number of keywords (P,A,S,H)for each employee.
P - Present
A - Absent
S - Sick Leave
H - Holiday

Im attaching the snapshot of the excel for your refernece.

Can any one help me


Thats a really beautiful scenario. Bit can you please Share a Sample Excel File. This helps us to find and validate a solution approach more fast. Thanks

Sure i will sahre the sample excel.

What i required is read each employee name and find the number of P,A,H & S for that particular employee.

Sheet.xlsx (19.0 KB)


I have created a xaml for your scenario try the attached file
excel.xaml (13.8 KB)