8 Replies Latest reply: Apr 17, 2016 6:35 AM by Stefan Wühl RSS

    Rows below a value

    Adnan Rafiq

      Hi Experts, I would like your help on this situation. See the table below

      AB
      ABC
      DEF
      HIJ
      HGT
      LMN
      OPQ

       

       

      I want to create a column B in the above table, which looks at A and sees value "DEF" and puts the value 100 in all the rows that are below DEF until it sees OPQ, so new table looks like this

                                  a                                                                                                  b

      ABC
      DEF
      HIJ100
      HGT100
      LMN100
      OPQ
      IUJ