I have a worksheet that has 5 columns and approximately 20,000 rows.
Only one cell in each row has a value other that zero. I want to
insert a column on the left that will have a formula that will look at
each value in each row and return the column heading for the column
that has the row containing a value other than zero. I have tried a
formula that says =if(c2<0,c1,(if(d2<0,d1),(if(e2<0,e1)
,(if(f2<0,f1),(if(g2<0,g1) but it did not work.

I hope this makes sense, and any help will surely be appreciated.


Dennis