ExcelHome技术论坛

 找回密码
 免费注册

QQ登录

只需一步,快速开始

快捷登录

搜索
EH技术汇-专业的职场技能充电站 妙哉!函数段子手趣味讲函数 Excel服务器-会Excel,做管理系统 效率神器,一键搞定繁琐工作
HR薪酬管理数字化实战 Excel 2021函数公式学习大典 Excel数据透视表实战秘技 打造核心竞争力的职场宝典
让更多数据处理,一键完成 数据工作者的案头书 免费直播课集锦 ExcelHome出品 - VBA代码宝免费下载
用ChatGPT与VBA一键搞定Excel WPS表格从入门到精通 Excel VBA经典代码实践指南
查看: 167|回复: 4

[已解决] 请教大佬一个简单的列内自动填充问题

[复制链接]

TA的精华主题

TA的得分主题

发表于 2024-5-29 09:04 | 显示全部楼层 |阅读模式
image.png image.png

如图,一列内的数字不连续填充,需要把空的单元格填充为上一个数字,我用if(A2=“”,A1,A2)只能填充有数字的下一个空单元格,第二个空单元格就不行了。有何办法解决?

weibo.com/ttarticle/p/show?id=2309405039290588725813
weibo.com/ttarticle/p/show?id=2309405039290592657426
weibo.com/ttarticle/p/show?id=2309405039290597113904
weibo.com/ttarticle/p/show?id=2309405039290613629103
weibo.com/ttarticle/p/show?id=2309405039290617823235
weibo.com/ttarticle/p/show?id=2309405039290622017589
weibo.com/ttarticle/p/show?id=2309405039290643251350
weibo.com/ttarticle/p/show?id=2309405039290647445741
weibo.com/ttarticle/p/show?id=2309405039290651377724
weibo.com/ttarticle/p/show?id=2309405039290668154913
weibo.com/ttarticle/p/show?id=2309405039290681000139
weibo.com/ttarticle/p/show?id=2309405039290689126433
weibo.com/ttarticle/p/show?id=2309405039290726875317
weibo.com/ttarticle/p/show?id=2309405039290735263843
weibo.com/ttarticle/p/show?id=2309405039290739458309
weibo.com/ttarticle/p/show?id=2309405039290752303261
weibo.com/ttarticle/p/show?id=2309405039290760691726
weibo.com/ttarticle/p/show?id=2309405039290768818304
weibo.com/ttarticle/p/show?id=2309405039290773275111
weibo.com/ttarticle/p/show?id=2309405039290781401213
weibo.com/ttarticle/p/show?id=2309405039290798440518
weibo.com/ttarticle/p/show?id=2309405039290798440521
weibo.com/ttarticle/p/show?id=2309405039290806829081
weibo.com/ttarticle/p/show?id=2309405039290823606602
weibo.com/ttarticle/p/show?id=2309405039290865549404
weibo.com/ttarticle/p/show?id=2309405039290873675904
weibo.com/ttarticle/p/show?id=2309405039290878132545
weibo.com/ttarticle/p/show?id=2309405039290890453124
weibo.com/ttarticle/p/show?id=2309405039290899104120
weibo.com/ttarticle/p/show?id=2309405039290903298102
weibo.com/ttarticle/p/show?id=2309405039290915881397
weibo.com/ttarticle/p/show?id=2309405039290924007471
weibo.com/ttarticle/p/show?id=2309405039290924269731
weibo.com/ttarticle/p/show?id=2309405039290941046885
weibo.com/ttarticle/p/show?id=2309405039290945241348
weibo.com/ttarticle/p/show?id=2309405039290945241444
weibo.com/ttarticle/p/show?id=2309405039290987184607
weibo.com/ttarticle/p/show?id=2309405039290995310643
weibo.com/ttarticle/p/show?id=2309405039291012350052
weibo.com/ttarticle/p/show?id=2309405039291016544539
weibo.com/ttarticle/p/show?id=2309405039291037515797
weibo.com/ttarticle/p/show?id=2309405039291041710348
weibo.com/ttarticle/p/show?id=2309405039291058487636
weibo.com/ttarticle/p/show?id=2309405039291062681837
weibo.com/ttarticle/p/show?id=2309405039291104624649
weibo.com/ttarticle/p/show?id=2309405039291104624816
weibo.com/ttarticle/p/show?id=2309405039291113013643
weibo.com/ttarticle/p/show?id=2309405039291125334223
weibo.com/ttarticle/p/show?id=2309405039291129790660
weibo.com/ttarticle/p/show?id=2309405039291137917039
weibo.com/ttarticle/p/show?id=2309405039291150762208
weibo.com/ttarticle/p/show?id=2309405039291150762413
weibo.com/ttarticle/p/show?id=2309405039291163344984
weibo.com/ttarticle/p/show?id=2309405039291175927812
weibo.com/ttarticle/p/show?id=2309405039291175927895
weibo.com/ttarticle/p/show?id=2309405039291188248591
weibo.com/ttarticle/p/show?id=2309405039291221803217
weibo.com/ttarticle/p/show?id=2309405039291225997671
weibo.com/ttarticle/p/show?id=2309405039291234648318
weibo.com/ttarticle/p/show?id=2309405039291247231198
weibo.com/ttarticle/p/show?id=2309405039291251163218
weibo.com/ttarticle/p/show?id=2309405039291272134711
weibo.com/ttarticle/p/show?id=2309405039291276329057
weibo.com/ttarticle/p/show?id=2309405039291293368623
weibo.com/ttarticle/p/show?id=2309405039291301757040
weibo.com/ttarticle/p/show?id=2309405039291305951304
weibo.com/ttarticle/p/show?id=2309405039291347894396
weibo.com/ttarticle/p/show?id=2309405039291410808969
weibo.com/ttarticle/p/show?id=2309405039291435974677
weibo.com/ttarticle/p/show?id=2309405039291456946553
weibo.com/ttarticle/p/show?id=2309405039291481849871
weibo.com/ttarticle/p/show?id=2309405039291524055266
weibo.com/ttarticle/p/show?id=2309405039291544764681
weibo.com/ttarticle/p/show?id=2309405039291569930288
weibo.com/ttarticle/p/show?id=2309405039291590901910
weibo.com/ttarticle/p/show?id=2309405039291628650574
weibo.com/ttarticle/p/show?id=2309405039291641495575
weibo.com/ttarticle/p/show?id=2309405039291653816341
weibo.com/ttarticle/p/show?id=2309405039291658010646
weibo.com/ttarticle/p/show?id=2309405039291662467547
weibo.com/ttarticle/p/show?id=2309405039291674787989
weibo.com/ttarticle/p/show?id=2309405039291687633088
weibo.com/ttarticle/p/show?id=2309405039291687633184
weibo.com/ttarticle/p/show?id=2309405039291699953697
weibo.com/ttarticle/p/show?id=2309405039291712536601
weibo.com/ttarticle/p/show?id=2309405039291742159074
weibo.com/ttarticle/p/show?id=2309405039291784101955
weibo.com/ttarticle/p/show?id=2309405039291821850904
weibo.com/ttarticle/p/show?id=2309405039291838627925
weibo.com/ttarticle/p/show?id=2309405039291851210813
weibo.com/ttarticle/p/show?id=2309405039291859599652
weibo.com/ttarticle/p/show?id=2309405039291871920299
weibo.com/ttarticle/p/show?id=2309405039291884765356
weibo.com/ttarticle/p/show?id=2309405039291897348579
weibo.com/ttarticle/p/show?id=2309405039291909668909
weibo.com/ttarticle/p/show?id=2309405039291914125456
weibo.com/ttarticle/p/show?id=2309405039291939291144
weibo.com/ttarticle/p/show?id=2309405039291960262982
weibo.com/ttarticle/p/show?id=2309405039291985428695
weibo.com/ttarticle/p/show?id=2309405039292018720892
weibo.com/ttarticle/p/show?id=2309405039292023177623
weibo.com/ttarticle/p/show?id=2309405039292043886797
weibo.com/ttarticle/p/show?id=2309405039292048343149
weibo.com/ttarticle/p/show?id=2309405039292069314576
weibo.com/ttarticle/p/show?id=2309405039292069314864
weibo.com/ttarticle/p/show?id=2309405039292090024010
weibo.com/ttarticle/p/show?id=2309405039292094480539
weibo.com/ttarticle/p/show?id=2309405039292148744279
weibo.com/ttarticle/p/show?id=2309405039292161327333
weibo.com/ttarticle/p/show?id=2309405039292165783917
weibo.com/ttarticle/p/show?id=2309405039292174172563
weibo.com/ttarticle/p/show?id=2309405039292186755464
weibo.com/ttarticle/p/show?id=2309405039292190949782
weibo.com/ttarticle/p/show?id=2309405039292199338254
weibo.com/ttarticle/p/show?id=2309405039292211921217
weibo.com/ttarticle/p/show?id=2309405039292216115500
weibo.com/ttarticle/p/show?id=2309405039292224241853
weibo.com/ttarticle/p/show?id=2309405039292245213211
weibo.com/ttarticle/p/show?id=2309405039292245475490
weibo.com/ttarticle/p/show?id=2309405039292279030084
weibo.com/ttarticle/p/show?id=2309405039292291350635
weibo.com/ttarticle/p/show?id=2309405039292291612850
weibo.com/ttarticle/p/show?id=2309405039292303933679
weibo.com/ttarticle/p/show?id=2309405039292316516445
weibo.com/ttarticle/p/show?id=2309405039292316778950




TA的精华主题

TA的得分主题

发表于 2024-5-29 09:46 | 显示全部楼层
=IF(A2="",A1,A2)

TA的精华主题

TA的得分主题

发表于 2024-5-29 09:54 | 显示全部楼层
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件       ★免费下载 ★       ★ 使用帮助
选择数据范围  ctrl+g 空格 =a2  ctrl+enter

TA的精华主题

TA的得分主题

发表于 2024-5-29 09:56 | 显示全部楼层
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件       ★免费下载 ★       ★ 使用帮助
选中整个区域,按F5打开定位,选择“空值”确定,点击编辑栏,输入=A2,按住Ctrl敲回车

TA的精华主题

TA的得分主题

发表于 2024-5-29 09:56 | 显示全部楼层
选中整列,ctrl+g打开定位,定位条件选空值,确定之后所有空单元格都被选中,这个时候直接在键盘输入【=】然后选择上一个单元格,最后CTRL+ENTER批量填充
您需要登录后才可以回帖 登录 | 免费注册

本版积分规则

手机版|关于我们|联系我们|ExcelHome

GMT+8, 2024-11-16 21:02 , Processed in 0.042306 second(s), 13 queries , Gzip On, MemCache On.

Powered by Discuz! X3.4

© 1999-2023 Wooffice Inc.

沪公网安备 31011702000001号 沪ICP备11019229号-2

本论坛言论纯属发表者个人意见,任何违反国家相关法律的言论,本站将协助国家相关部门追究发言者责任!     本站特聘法律顾问:李志群律师

快速回复 返回顶部 返回列表