Forum Discussion

olavmeling's avatar
olavmeling
Copper Contributor
Feb 06, 2019

Need help creating a formula

Hi, Can anyone help me create a formula that looks for all numbers in a column that also has a certain number in its row (19-2) ?  
excel
Formulas and Functions
olavmeling's avatar
olavmeling
Copper Contributor
Feb 07, 2019

Thank you Nauthstar for your answer, but I did not manage to place the formula. Could you try to place the formula in the attached file?

 

Thank you very much for your time!

Nauthstar's avatar
Nauthstar
Iron Contributor
Feb 07, 2019

Hi, Try the attached.  You can add new rows and the table will expand automatically.

 

N

  • olavmeling's avatar
    olavmeling
    Copper Contributor
    Feb 07, 2019

    Thank you for your answer Nauthstar , we're getting close!

     

    I do not need the rows to turn yellow, but i do need the numbers (Beløp) that are marked 19-1 (Fakturamnd) and so on, to show up in the column on the right that is also marked 19-1 / 19-2 / 19-3...

     

    When i copied your formula into my file, it says "true", if "true could be replaced with the corresponding number that would be great.

     

    Thank you for your help so far!

    • olavmeling's avatar
      olavmeling
      Copper Contributor
      Feb 07, 2019

      Hi again Nauthstar , i figured it out! Thank you wery much for your help! It was great!!

      • Nauthstar's avatar
        Nauthstar
        Iron Contributor
        Feb 08, 2019
        Excellent! You just needed to replace the "True" with the O$2 ;-)

Resources