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