Results 1 to 7 of 7

Thread: Need help auto generate columns

  1. #1

    Need help auto generate columns



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Can you upload the file so we can understand clearly

  3. #3
    Here it is....In that sheet "What_I_need" shows what I want, in sheet "con"....
    Attached Files Attached Files

  4. #4
    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

  5. #5
    Quote Originally Posted by saltarazan View Post
    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
    Sorry it doesn't work ....

  6. #6
    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.

  7. #7
    Quote Originally Posted by saltarazan View Post
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •