I have a random assortment of static values ranging from 0-5 in cells C3:Y3. How do I locate the highest column number containing a non zero? I've tried: 
=MATCH(0,C3:Y3,0)
Which of course will locate the first 0 and return the position in the array. Note that zeros may appear in the row more than once, followed by non zero values:
0,1,5,0,0,5,2,3,0,0,0,0,5,3,4,3,2,0,0,1,0,0,0

In the above sample, the 20th item in the array is a 1 which is what I'd like to return the position for.