need help identifying first nonzero column
I have a large dataset with around 30 columns of time-dated financial entries. I want to know which column is the first with a nonzero (no columns have missing data, but I want to get the first column with a positive value entry) value. I've attached a small made-up example with four time columns and a fifth column showing what I'd like my formula to result in. If the zero values were missing, ...
dale_lehman
albiruni81
David_Burnham