View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dkline Dkline is offline
external usenet poster
 
Posts: 75
Default Last Value Greater than Zero in a column

In a column of 121 numbers which can be positive or negative or zero, is
there a function to find the last positive value in the column?

Or do I need to build a UDF?