请教Excel大神: how to autofill cells with different subtitles

开心小石头
楼主 (北美华人网)
各位excel大神们,请问一下如何auto fill in类似下面highlighted cells with different regions。Data比较大,有上万个rows,没法直接drag。先谢谢各位了!
m
marychung
用POWERE QUERY,进入POQWER QUERY EDIT界面,选中这REGOION一列,点右键,有一个自动fill选项
如果这个表是数据透视表,不用PQ,直接就可以自动FILL
teapot
用POWERE QUERY,进入POQWER QUERY EDIT界面,选中这REGOION一列,点右键,有一个自动fill选项
如果这个表是数据透视表,不用PQ,直接就可以自动FILL
marychung 发表于 2021-11-24 10:29

Mark一下
doudouzhuang
提前复制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
aliciaa
Mark一下~
annettezhang
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
失去耐心了
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

这也是我的办法
wjttg
Mark, 用过但经常忘,谢谢楼上妹子
lavendula
好帖子,进来学习了几招。不过现在知识技术真的就是在指尖,网上的教程攻略只有我想不到,没有教不到。
开心小石头
跪谢各位大神支招!
cottonfield
mark
Jimatssf
问题都没看懂
muscle086
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

对对,我也是这么用的
majia909
mark一下~~~
s
sherryla
学习了,多谢!