提前复制region column, 在想要放所有region的column用下面的公式 如果 unit 非空 并且 unit上面是空的,apply提前复制出去的region 否则 如果unit 非空(但是unit上面也非空), apply上面一行已经有的region 否则 fill in empty =if(and(not(isblank(B2)) , isblank(B1) ) , A2, if(not(isblank(B2)) , C1, "") ) column A: copy of region column B: unit column C: region to be filled
select the region to be filled>find & select>go to special>blanks>from the highlighted cell, type in = sign and cell name of the above row. for example, if highlighted cell is a3, then type in "=a2">hit ctrl+enter
select the region to be filled>find & select>go to special>blanks>from the highlighted cell, type in = sign and cell name of the above row. for example, if highlighted cell is a3, then type in "=a2">hit ctrl+enter
youtube has everything annettezhang 发表于 2021-11-24 12:31
select the region to be filled>find & select>go to special>blanks>from the highlighted cell, type in = sign and cell name of the above row. for example, if highlighted cell is a3, then type in "=a2">hit ctrl+enter
youtube has everything annettezhang 发表于 2021-11-24 12:31
如果这个表是数据透视表,不用PQ,直接就可以自动FILL
Mark一下
如果 unit 非空 并且 unit上面是空的,apply提前复制出去的region 否则 如果unit 非空(但是unit上面也非空), apply上面一行已经有的region 否则 fill in empty
=if(and(not(isblank(B2)) , isblank(B1) ) , A2, if(not(isblank(B2)) , C1, "") )
column A: copy of region column B: unit column C: region to be filled
youtube has everything
这也是我的办法
对对,我也是这么用的