Basically

i have hundreds of rows

the top row has a date going out for many columns , so picture this

1/1 2/1 3/1 4/1 5/1 6/1
10 8 7 0 -4 -6 -8

and then rows of numbers, with the date only in the first row

I need to find out the first number equal to or less than 0 in each
row and pull the date for that number.  So, when searches down this
row in the example above, it sees 0, which is in the fourth column,
that fourth column refers to the date 4/1.  Picture it as many bank
accounts that are depleting.  At what date will the bank account
become empty or negative

one thing to note, sometimes my data as non-numeric values and is not
in order.  but in general, its to be expected to be decrementing
numbers

make sense?

thanks, Josh