Try this...

Assume your data is in the range B2:B20

Array entered** :

=MATCH(TRUE,B2:B20<0,0)+ROW(B2)-1

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"russhess8" wrote in message
...
I have a list of values in column b. I want to find the first time that
this
value is less than zero. I then want to list the corresponding row in
column
a. any suggestions?