excelscreenie.jpg
What I'm trying to do is pivot this data and then get the count of No in the Rows filtered by the Headers 1.1, 1.2, 1.3, etc.
Like
1.1 23 No's
1.2 20 No's
Then my report filter would be the Group number.
Thanks.
excelscreenie.jpg
What I'm trying to do is pivot this data and then get the count of No in the Rows filtered by the Headers 1.1, 1.2, 1.3, etc.
Like
1.1 23 No's
1.2 20 No's
Then my report filter would be the Group number.
Thanks.
Maybe you are able to re-arange your data in a table.
Probably it can be done with a macro.
After that is easier to use a pivot table.
If you add a file (without confidentional information) I will take a look at it.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks