Hi,
I would like a little help on the formula below please.
I am trying to search for a negative number across all worksheets (I have named a range of their names as MySheets - each worksheet is a year)
The column I am searching is F, and I want to return the cell value of A when it finds the first negative number.
IF(COUNTIF("'"&INDEX(MySheets&(F11:F499,"<0"))),"'"&INDEX(MySheets&(A11:A499,MATCH(TRUE,"'"&INDEX(MySheets&(F11:F499<0,0),0)))),"No negative numbers")
Thanks in advance
Paul
I would like a little help on the formula below please.
I am trying to search for a negative number across all worksheets (I have named a range of their names as MySheets - each worksheet is a year)
The column I am searching is F, and I want to return the cell value of A when it finds the first negative number.
IF(COUNTIF("'"&INDEX(MySheets&(F11:F499,"<0"))),"'"&INDEX(MySheets&(A11:A499,MATCH(TRUE,"'"&INDEX(MySheets&(F11:F499<0,0),0)))),"No negative numbers")
Thanks in advance
Paul