Need Alternate Code or Formula
Hi friends,
I have the formula below, it is in column BR. It goes from column V to BN
and it should be copied down from row3 to Row 700. The problem I am having is
the formula is too long for the cell, what would be the equivalent VBA code
or is there a different formula that will work for this?
Thanks for any assistance you can provide.
=IF(V3="X",V$1, )& &iF(W3="x",W$1,)& &IF(X3="x",X$1 ,)&
&IF(Y3="x",Y$1 ,)& &IF(Z3="x",Z$1& & ,)& &IF(AA3="x",AA$1 ,)&
&IF(AB3="x",AB$1 ,)& &IF(AC3="x",AC$1 ,)& &IF(AD3="x",AD$1 ,)&
&IF(AE3="x",AE$1 ,)& &IF(AF3="x",AF$1 ,)& &IF(AG3="x",AG$1 ,)&
&IF(AH3="x",AH$1 ,)& &IF(AI3="x",AI$1 ,)& &IF(AJ3="x",AJ$1 ,)
The sheet looks like this:
v w BR
1Criteria1 Criteria 2
2 x =if(V2="x",V$1,"")&" "&if(W2="x",W$1,"")
3 x x =if(V3="x",V$1,"")&" "&if(W3="x",W$1,"")
4
--
Danielle :<)
|