View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
VCUE VCUE is offline
external usenet poster
 
Posts: 4
Default First Positive on Horizontal Array

Is there a function that results/looks for the first single positive (non
zero) value in a Horizontal Array?
For example:
A B C D E F
Row 1: 0 2 5 1 0 2
Return the value that will be the first positive in the array, which will be
"2".