"aldsv" wrote in
message ...

A dozen google searches didn't solve this problem, but I know you
can...

I have a row of data (I actually have a lot of rows, and a lot of
columns):

[0,0,0,5,2,0,3]

I need a formula to find the column# of the first cell with <0 data.

Given $K$71:$Q$71 the row containing your data, the following
returns 14 (column N containing 5):

{=MIN(IF(IF($K$71:$Q$71<0,COLUMN($K$71:$Q$71),0) 0,
IF($K$71:$Q$71<0,COLUMN($K$71:$Q$71),0)))}
FormulaArray

Ciao
Bruno