First Over 0

Giganews Newsgroups
Subject: First Over 0
Posted by:  Blackcat
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.

eg
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.

Thanks

Replies