I have 3 merged cells - I know we should try to avoid merged cells but it is needed for proper graphical representation of a schedule.
Example: D35:D377 with value "YES"
Is there a way to automatically equate 3 separate cells to this merged cell's value? Example, E35=D35, E36 =D35, E37=D37, each indicating "YES"
When I set the formula for E35 (=D35) and drag down to E37, E35 = "YES" but the E36 and E37 are left blank. Attached is an example.
I tried this formula =IF(D35="",IF(D34="",D33,D34),D35). This doesn't seem to work since it will populate cells even if a merge cell doesn't exist for that row and will incorrectly look at a previous merged cell.
Appreciate any help. TIA!
Example: D35:D377 with value "YES"
Is there a way to automatically equate 3 separate cells to this merged cell's value? Example, E35=D35, E36 =D35, E37=D37, each indicating "YES"
When I set the formula for E35 (=D35) and drag down to E37, E35 = "YES" but the E36 and E37 are left blank. Attached is an example.
I tried this formula =IF(D35="",IF(D34="",D33,D34),D35). This doesn't seem to work since it will populate cells even if a merge cell doesn't exist for that row and will incorrectly look at a previous merged cell.
Appreciate any help. TIA!