Find first cell in a range not zero


MATCH(TRUE,INDEX($A1:$AE1>0,0),0)

Source:
http://www.excelforum.com/excel-general/679226-find-the-first-value-in-a-row-greater-than-zero.html