Date & Cell Contents Vs.Value Plotted.

[thilag]

Hello Friends

Please find the attached file <date vs. value2.xlsx>

I had a formula in Cell K3 which shows the text of Cell G3 (C). Now if we make all the cells C3,D3 & E3 is blank (i.e., deleting the cell content) then the formula reading the previous cell G2 Text (B) in Cell K3.

Instead my requirement is if any one of the cell C3 or D3 or E3 is blank then it should display the previous cell content i.e, B (Previous Cell G2) in K3.

thanks in advance

thilag

[samba_ravi]

{=INDEX($G$1:$G$3,IF(COUNTIF($C$1:$E$3,"")=0,ROWS($C$1:$C$3),MIN(IF($C$1:$E$3="",ROW($C$1:$E$3)-1))))}
Try this array (Shift + Alt + Enter) formula