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

[helge_jorg]

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

[sunny_talwar]

Is this something you need to be done in the script or front end? Also, can you provide the Excel as a attachment and what is the expected output from this Excel?

Best,

Sunny