Hello,
I'm doing Staff Training Report Management for my workplace and I stuck with extracting data base on what I need and I need your help. Below is the example of my data table looks like. It contains information about staffs who have been offered training in various types such as: Master Degree, Meeting, Workshop and other courses ect...
And I want to Filter how many staffs have been joining training programs in types of "Meeting" for example, in Row 4, Excel show "Mr C" but Row 14:16, Excel shows only "JKL" as shown in below picture:
And suppose that I want to find who and what type of training are funded by "ABC", excel shows only Row 14 "JKL" and Row 17 "XYZ".
Please help me how to enable Excel to show all information correctly.
I'm doing Staff Training Report Management for my workplace and I stuck with extracting data base on what I need and I need your help. Below is the example of my data table looks like. It contains information about staffs who have been offered training in various types such as: Master Degree, Meeting, Workshop and other courses ect...
And I want to Filter how many staffs have been joining training programs in types of "Meeting" for example, in Row 4, Excel show "Mr C" but Row 14:16, Excel shows only "JKL" as shown in below picture:
And suppose that I want to find who and what type of training are funded by "ABC", excel shows only Row 14 "JKL" and Row 17 "XYZ".
Please help me how to enable Excel to show all information correctly.