View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mlh97 mlh97 is offline
external usenet poster
 
Posts: 1
Default don't know how to ask the Q

is there a function that will return the first non-zero cell in a given range?

For example, I have a range of 20 cells in a row (say column A through
column T), and I want the function (or seried of functions) to look within
the range and return the value furthest to the right. Like, in row 1, the
first value is in column C. In row 2, the first value may be in column F. In
row 3, the first value may be in column S.

Thanks for the help.