First and Last Sales with Exapmle

[dta.mo]

Looking for a way to identify first and last non zero cells within a cell range. Attachment for demo purposes. Thanks!!

[p45cal]

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.

[dta.mo]

Thanks! I didn't know the Ctrl+Shift+Enter need for an array formula, thus the repost. I've communicated the same to Bob who answered initially - he followed up also with the array part.

So then, thanks for part 2 answer!

Cheers!