Hi everyone.
I've been struggling with something that I think must be quite simple but I'm overthinking it.
I need to count how many sequential times a group of conditions repeat. In the example bellow you may see what I'm talking about:
[table="width: 500"]
[tr]
Date Location Type Result
01/10/2020 1/20 Test Conform
02/10/2020 2/35 Test Conform
03/10/2020 2/25 Test Non-conform
04/10/2020 1/20 Repetition Conform
05/10/2020 1/25 Test Non-conform
06/10/2020 1/25 Repetition Non-conform
07/10/2020 1/25 Test Conform
08/10/2020 1/20 Test Non-conform
09/10/2020 1/20 Repetition Non-conform
10/10/2020 1/20 Test Non-conform
11/10/2020 1/35 Test Non-conform
20/10/2020 1/25 Test Non-conform
20/10/2020 1/20 Test Conform
I need excel to count how many non-conform tests occur per location but the "Repetition" type don't count, the counting is only if two sequential test are non-conform and if a result, for instance, for location 1/20 is "non-conform", then the next test for this location is "conform" the counting should reset.
I tried to create a dynamic table for this and it helped me visualize how many sequential values are "non-conform" but I can't seem to figure how to count them only if the are adjacent to each other.
Please help!!
Bookmarks