Getting the count of keywords in each for each employee

Help
, ,
1

Hi,
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

Regards
Sajin

Sheet
Sheet1186×171 5.33 KB

2

@Sajin_91
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

3

Hi,
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)

4

@Sajin_91

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