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
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