View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
George George is offline
external usenet poster
 
Posts: 347
Default Find first positive value in a column

I am trying to create a formula that will:
1. Search a column of numbers to find the first row with a positive number
2. Once found, I need to reference another column on the same row which
contains a date.
3. Finally, subtract that date from a fixed date (Jan 1, 2007) to end up
with a number.

I'm fairly new to Excel and wonder if this can be done with a formula or if
I need to get into VB script (hope not) .
Any help would be appreciated.