The attached file shows a small sample of my Data Table and an Analysis Summary Table which I want to produce.
The analysis is on each of the groups of results with the same Pattern No. within the Data Table.
I think its best to use VBA but not sure how to set it up so any pointers would be appreciated. (I have a little VBA experience but not enough to know how to approach this problem)
In the attached example -
Cell H5 shows the first unique pattern number
Cell I5 shows the number of times that pattern occurred in the Data Table.
Cell J5 shows the percentage of times that the #100 Pattern produced a Green output
Cell K5 shows the Average of the Ratings produced by all of the #100 Green Patterns
Thank you for reading my post.
I am using Excel 2013 on Windows 7
Bookmarks