View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Iriemon Iriemon is offline
external usenet poster
 
Posts: 89
Default First negative number

I've got a spreadsheet with a list of values in col "A" sorted in descending
(not ascending) order. Col "B" has a date. I need a formula that returns the
date the value in col "A" first turns into a negative number. In the sample
below it should return the date Jan 07

Thanks

100 Oct 06
30 Nov 06
10 Dec 06
-10 Jan 07
-75 Feb 07