Hi Guys!
I have a column where I need to find the first non zero value and have whatever that lowest value is be returned in a different cell. In the example provided it would be 5 that Id liked returned in A16. The colunm itself changes based upon other inputs so any one cell from A1 till A13 could be all 0. Ive been using =INDEX(A1:A14,MATCH(0,A1:A14,-1)) in array format as well but it just keep returning 12 as the answer.
Any thoughts?
Much love,
Chin
Bookmarks