|Subject:||First Over 0|
|Date:||Wed, 3 May 2006|
I have two rows of cells, the first row contains a financial year ie 06/07.
The second contains values relating to that year.
I need a formula that will find the cell that contains the first value in
the row that is 0 or greater and prroduce the year as the answer.
06/07 07/08 08/09 09/10 10/11
-15 -10 -10 12 11
In this example the answer would be 09/10
I'm struggling with lookup and match so any help would be greatly appreciated.