Okay that's the third time the rules have changed.
Try this
With your Names in Column A and your data beginning in Column C
In B1
This will handle up to 16 numbers per row.![]()
=IF(SUMPRODUCT(--(C1:R1>0),--(D1:S1>0)-1)=-1,"Yes","No")
Or a dynamic solution
The number of entered numbers per row is only limited by the sheet width![]()
=IF(SUMPRODUCT(--(C1:INDEX(1:1,1,MATCH(99^99,1:1,1))>0),--(D1:INDEX(1:1,1,MATCH(99^99,1:1,1)+1)>0)-1)=-1,"Yes","No")
Bookmarks