Joined: 23 Apr 2009
Location: Sydney, Australia
|Posted: Fri Mar 23, 2012 3:55 pm Post subject:
|I think you need to use a helper row.
Assuming the absence of a zero is enough to indicate that all four names are present, then...
in A6 filled across to C6 will return TRUE, FALSE, TRUE in A6:C6.
Then this formula in A5 filled across to C5...
will return 1, 0, 2 in A5:C5.
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).