Need help auto generate columns

pandeec

New member
Joined
Feb 7, 2013
Messages
7
Reaction score
0
Points
0
Hi... when I enter a name (A2) automatically in B3 SEX, B4 BMI, B5 HEIGHT, B6 WEIGHT vice versa… should be generate.. . when we enter next name in cell A7 the Name of items(SEX,BMI,HEIGHT,WEIGHT) will generate in columns B (cells B8 SEX ,B9 BMI .B10 HEIGHT .B12 WEIGHT) Likewise CELLS A2,A7,A12 ....have names then corresponding cells of B columns genrerate the items name(SEX,BMI,HEIGHT,WEIGHT... If I delete the name in (exaple) cell A2 then cells B2,B3,B4,B5 would became blank . Simply if cell A2 is blank then B2,B3,B4,B5 would be blank… So when cell Ax has letters then cells Bx+1 =Sex, Bx+2=Bmi,Bx+3=Height,Bx+4=weight would be displayed, at the same If cell Ax is blank then Bx+1,Bx+2,Bx+3,Bx+4 would blank.. I neeeed that formula… Thank in advance…. In anticipation
 

pandeec

New member
Joined
Feb 7, 2013
Messages
7
Reaction score
0
Points
0
Here it is....In that sheet "What_I_need" shows what I want, in sheet "con"....
 

Attachments

  • stafprofile.xlsx
    17.3 KB · Views: 11

saltarazan

New member
Joined
Jan 18, 2013
Messages
16
Reaction score
0
Points
0
In cell B13 you can you use this formula and get what you want (the same for Height, Weight, BMI) :
=IF(ISTEXT(A12),"","Sex")

hope that helps
 

saltarazan

New member
Joined
Jan 18, 2013
Messages
16
Reaction score
0
Points
0
Ok, take this one, it should work (put it in B3) :
=IF(LEN(A2)<1,"","Sex")

(Explanation: if the length of the word in A2 is less than 1 (i.e. blank) then leave it blank, else put Sex)
 
Last edited:

pandeec

New member
Joined
Feb 7, 2013
Messages
7
Reaction score
0
Points
0
Ok, take this one, it should work (put it in B3) :
=IF(LEN(A2)<1,"","Sex")

(Explanation: if the length of the word in A2 is less than 1 (i.e. blank) then leave it blank, else put Sex)

It is really good ya.... I didn't think, abouth this point... Thank you so much
 
Top