I am stuck at something, please help me out.sample1.xlsx (67.3 KB)
I have an large excel file with constant headers. i want each group count and average of grades columns by selecting filters on each columns with completed and completed(*)
as shown in below image.
like first filter group and select one group then second filter columns by selecting completed and completed (*) and count and average grade value like this for each group.
as you can see in above image there are some column names, for them i want count of completed and completed () and average of grade colomn beside them for only completed and completed () and store the result.
i have lot of files like this to process, please help me out…