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.

I tried various combinations of match, min, max and array formulas to
no success

Thanks in advance.

aldsv


--
aldsv
------------------------------------------------------------------------
aldsv's Profile: http://www.excelforum.com/member.php...o&userid=20494
View this thread: http://www.excelforum.com/showthread...hreadid=479037