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)