Results 1 to 10 of 13

Thread: Populate Column with Answers

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Acolyte oskar's Avatar
    Join Date
    May 2013
    Location
    Montreal, Canada
    Posts
    24
    Articles
    0
    Excel Version
    Office 2013

    Populate Column with Answers

    I want to populate column E (Answer) with the results of multiplying column C (Factor) by column D (Input), rows 5-16, as per attached file.

    Column D now shows a 10 at row 8 so the 10 should be multiplied by each factor of column C and the answers should be shown in column E. Then when I input another number anywhere in column D that number should again be multiplied by each factor from column C. There is no need to save the results in column E

    The formula shown on the same sheet which for some unexplained reason when I write it on the VB Editor does not stay there after I exit the file although I save it. This formula I found it on the web but it does not work, perhaps Iím missing something?

    Thank you
    Attached Files Attached Files

  2. #2
    Acolyte oskar's Avatar
    Join Date
    May 2013
    Location
    Montreal, Canada
    Posts
    24
    Articles
    0
    Excel Version
    Office 2013
    I found a way but don’t know if it’s the best

    In column E write the formula =C5*$D$5 and copy it down to row 16, plus merge the cells in column D so there is only one row in the range

  3. #3
    Acolyte caabyyc's Avatar
    Join Date
    Dec 2014
    Location
    Burnaby/Calgary
    Posts
    24
    Articles
    0
    Excel Version
    2016
    I am not sure I completely understand your request ,just wrote formula as follow by guessing.

    Assume you will only enter one numerical number in D516

    E5=C5&MAX($D$5:$D$16)

  4. #4
    Acolyte oskar's Avatar
    Join Date
    May 2013
    Location
    Montreal, Canada
    Posts
    24
    Articles
    0
    Excel Version
    Office 2013
    Quote Originally Posted by caabyyc View Post
    I am not sure I completely understand your request ,just wrote formula as follow by guessing.

    Assume you will only enter one numerical number in D516

    E5=C5&MAX($D$5:$D$16)
    Thank you caabyyc for the help

    I just realized my #2 post is wrong and does not give me what I want. Basically what I have is a units converter, in column D I find the row of the unit I want to convert, letís say 10 feet, so I insert 10 in row 6 and I should get the equivalent of 10 feet to all other units

    Yes at D5:16 is only numbers

    Where do I insert your formula?

  5. #5
    Acolyte Fluff's Avatar
    Join Date
    Sep 2018
    Posts
    82
    Articles
    0
    Excel Version
    O365
    If you put the number in E1 & the original Unit in F1, you can use this in E5 copied down
    =CONVERT($E$1,$F$1,B5)

  6. #6
    Acolyte oskar's Avatar
    Join Date
    May 2013
    Location
    Montreal, Canada
    Posts
    24
    Articles
    0
    Excel Version
    Office 2013
    Quote Originally Posted by Fluff View Post
    If you put the number in E1 & the original Unit in F1, you can use this in E5 copied down
    =CONVERT($E$1,$F$1,B5)

    You might be into something good here Fluff


    When you say the “number in E1” I assume you mean the Input. I did that and all the rest but I get on E5, #N/A.


    Can you explain how this formula should work?


    Thank you

Posting Permissions

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