[ via selecting G18:G22 (with G18 active), and using the formula:
=SUMPRODUCT(COUNTIF(H18:V18,$G$2:$K$16))=15 ]
Oops, just realized that the CF formula above,
following normal COUNTIF syntax should actually be written as:
=SUMPRODUCT(COUNTIF($G$2:$K$16,H18:V18))=15
But in this instance, think the earlier one works just as well
(Thanks to symmetry!)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--