Re: Location Of First Negative Value In Range
Thanks, but that returns #N/A?
Hope I explained correctly - will try some more detail.
The first 8 columns contain either text, zeros or positive numbers. Columns 9-20 contain the numbers I want to test. The first negative number may be in column 9 or anywhere beyond that, and it may be followed by further negative numbers, i.e. any of the numbers in columns 9-20 could be negative, positive or zero. I just want the column number of the first negative number from left to right.
Thanks for your help and your super-quick reply![hr]*[/hr] Auto Merged Post Until 24 Hrs Passes;[dl]*[/dl]Have also checked that there are no #N/A values elsewhere in the row.
Thanks