你说的这个叫筛选功能。
可以用高级筛选功能实现,也可以用公式筛选实现。
追问不是在同个工作表中实现,而是工作表A中更新后,工作表B中自动调用
追答不同表也可以高级筛选,目标位置选其它表就行了:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/bd315c6034a85edf3160197b46540923dc5475fe?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
公式筛选也可以
高级筛选支持跨表,公式筛选也可以,例如:
=INDEX(A:A,SMALL(IF($C:$C=$F$2,ROW($C:$C),4^8),ROW($A1)))&""
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/42166d224f4a20a41ed6da9f9f529822730ed09a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
追问请问按照这个公式出现#NUM!是哪里出错了
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/cefc1e178a82b901f2a3ca6a7c8da9773912ef59?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
追答ctrl+shift+enter
追问![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b3fb43166d224f4acb6b794a06f790529922d1fd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
我这里哪一步出错了,从其他表格调用公式就没用了
追答没有按:ctrl+shift+enter
本回答被提问者采纳