can you please explain which tab are you referring to. Data in the excel is not very clear.
below is the screenshot for A employee data
but I want to show for A person all the course name 1 and category coloum. like person a has completed 9 course name in course name 1 col. like this in course name 1 I have 15 courses , so I want to show all 15 courses for a person , 9 should be with completed status and remain should show not complete.
2. second req is u can see devops excecutive academy under course name (D Col) its falling under course name 1 category nd same course will fall under 1 more category under course name1 Delivery .so if person A has been completed devops excecutive course so for other category delivery also it should show mark as a complete.
if A has completed any for devops executive academy course name 1 all courses should mark as a complete
please let me know if u have any doubts
1. in below screenshot data is without filter.
if we filter with email@example.com it will show whatever a has completed that course only.
so my req is I want to display all the courses corresponding to person email id weather he has completed or not.
2. another req is in 1 screenshot u can see highlighted courses agile devops exce the same course is repeating in leading safe course name 1 category with R- agile devops exe. so if any of emp completed agile devops exce or R- agile it should show mark as a comp in both of course category.
3. Like in leading safe if person has completed 1 course also leading safe (Course name 1) all courses should mark as a complete