1 Reply Latest reply: Oct 12, 2016 11:57 AM by Sunny Talwar RSS

    If a cell is bank – show value from previous cell...

    Helge Jørgensen

      Hi all,

       

      I have a dataset where I need to plot the value from Company share [%] if the Date licensee to is blank. And if the Date licensee to has a value, I need it to be excluded from the plot. I just want Company share [%] to give a value when Date licensee to is blank.

       

      See the attached image of the excel-sheet.

       

      Hopefully some of you can help me with this

       

      Thanks

      Helge
      snip_20161012111540.png