Frist match from three arrays

[Calgary_Neil]

Hello again;

I was trying to use the follow formula
=MIN( SUMPRODUCT( N( MOD( COLUMN( Production!$C82:$FI82)+4, 7)=0),
N( Production!$C82:$FI82= 1 ),
COLUMN( Production!$C82:$FI82) ))
to return the column number of the the first cell to have 1. It should return 3, but returns 13 (3 +10).
It is returning the sum of the columns that have 2 (Duh).

The Sumproduct works as follows:
Part A creates a mask for the cells I'm interested in. 1,0,0,0,0,0,0,1 ...
Part B checks all cells for the Value (1) 1,0,0,0,0,0,0,1 ...
Part C returns the the column number 3,4,5,6,7,8,9,10, ...
The Min doesn't do anything (bahh)

Neil Excel 365

 

[Calgary_Neil]

What a brain fart this is.
replace min( sumproduct( with small(
the commas within sumproduct with *
add ,2 at the end (zero will always be smallest)
Ahis gives