Jun 07 2021 08:52 AM
Hi,
I am trying to generate a summary table with percentages (example of what I want on the right) but I want to do this across the ranges for all test points. So for test point 2, I want excel to calculate the percentage of P, W and F (Pass, Warning, Fail) for range A26:A55 and then so on for all the other test points. Is there a way to automate this using a pivot table or macro?
Once this is done for all test points, I want to filter for test points that had a high failure rate (>50% F).
Thanks.
Jun 07 2021 09:39 AM
@OmkarJ1996 Not sure if it answers your question completely, but the attached file contains a pivot table that seems to summarise most of what you asked for.