You already had an answer to the first non-zero cell from xld in your previos thread:http://www.excelguru.ca/forums/showt...Stop-Positions
Specifically:
=MATCH(1,IF(C5:N5<>0,1),0)
For the last non-zero cell:
=MAX((C5:N5<>0)*(COLUMN(C5:N5)-COLUMN(C5)+1))
or if you're not going to move the range:
=MAX((C5:N5<>0)*(COLUMN(C5:N5)-2))
all formule to be array-entered with Ctrl+Shift+Enter.
Bookmarks