Primary Secondary
F V
P T
F T
L V
H Y
F V
T T
X V
F I
F T
T T
P V
H V
Z SC
H V
F V
L V
H Y
F I
Sheet 1 contains two columns (above) titled "Primary" and "Secondary". On sheet 2 needs to enter a formula that gives a count of e.g. "FV"s ("F" from "Primary" column that matches with "V" in "Secondary" column. This is for Excel 2003.
Bookmarks