天问-高知学习中心

General Category => 网站软件工具 => Topic started by: laofuzi on December 08, 2022, 08:24:19 PM

Title: 【天问】Excel两列数据找出相同项自动对应
Post by: laofuzi on December 08, 2022, 08:24:19 PM

https://jingyan.baidu.com/article/ce09321b5b00646aff858fbc.html (https://jingyan.baidu.com/article/ce09321b5b00646aff858fbc.html)


=IF(COUNTIF(B$1:B$156,A2)=0,"",A2)

B$1:B$156这是第二列的数据选择，如果第二列数据很多，需要把156改大一点。