Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |