Forum Discussion
Kamil_Kuczyski
Feb 13, 2023Copper Contributor
How to fill empty cells with the next not empty cell from the same row?
Welcome. I have been looking for two hours, but I can't find the answer: How do I fill empty cells in excel with the next value in the row? Well, I have the column year 1990. Sometimes there is a ...
peiyezhu
Feb 14, 2023Bronze Contributor
Second question: Why this formula is wrong for above excel?
=IF(B2="",C1,B2)
similar to formular in c24?
=IF(C24="",D24,G24)
i guess you refer to c24 self in the formular.
if so,u had put =IF(B2="",C1,B2) in cell B2 I guess.
try put this formula to b1 rather than B2.
=IF(B2="",C1,B2)
similar to formular in c24?
=IF(C24="",D24,G24)
i guess you refer to c24 self in the formular.
if so,u had put =IF(B2="",C1,B2) in cell B2 I guess.
try put this formula to b1 rather than B2.