This function - IF(C10=$BX$5,$BO$4,"")....... is written in cells BX10:BX500.......
and work correctly in single row, but every time the new row start, for sample: .....IF(C11=$BX$5,$BO$4,"")
data in previous cell BX in that case BX10 disappear.

It is possible to create formula that prevent that??


Please help