SHEET 1:
COL A : has test names (Test1, test2, etc.)
Where COL A can repeat a test (test1, test1, test2, test3, test1, test2, test2, etc.)
COL B : has Pass or Fail.
SHEET 2:
In COL A I have a list of all unique tests (test1, test2, etc.)
In COL B I'd like a count of unique tests from sheet1 col a.
In COL B "PASS" I'd like a count of pass for each test.
In COL C "FAIL" I'd like a count of fail for each test
I tried using arrays, countif for the COLA AND COLB of sheet2, but I'm stumped.
COL A : has test names (Test1, test2, etc.)
Where COL A can repeat a test (test1, test1, test2, test3, test1, test2, test2, etc.)
COL B : has Pass or Fail.
SHEET 2:
In COL A I have a list of all unique tests (test1, test2, etc.)
In COL B I'd like a count of unique tests from sheet1 col a.
In COL B "PASS" I'd like a count of pass for each test.
In COL C "FAIL" I'd like a count of fail for each test
I tried using arrays, countif for the COLA AND COLB of sheet2, but I'm stumped.