Can you upload the file so we can understand clearly
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
Can you upload the file so we can understand clearly
Here it is....In that sheet "What_I_need" shows what I want, in sheet "con"....
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
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 by saltarazan; 2013-02-11 at 12:15 PM.
Bookmarks