| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 :<) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for sum of alternate cells | Excel Worksheet Functions | |||
| formula alternate column call value | Excel Worksheet Functions | |||
| formula alternate column call value | Excel Worksheet Functions | |||
| Formula at alternate Cell Values | Excel Worksheet Functions | |||
| Button Code to Alternate Sort Order ? | Excel Programming | |||
Threaded Mode
