如何在excel两个表中找出相同数据或者单元格

将公式

=COUNTIF(Sheet2!A:A,A2)

复制后粘贴至”Sheet1″后面空白列第二行(这里用”B2″单元格演示)将公式中的”A:A”改为”Sheet2″中”代码”所在列的列标如”H:H”T等),将公式中的”A2″改为”Sheet1″中”代码”第二行的单元格代码(“F2″等),对准右下角,光标成”+”状时双击

显示不为”0″的就是重复的.

好可用函数VLOOKUP:

将公式

=VLOOKUP(A2,Sheet1!A:A,1,0)

复制后粘贴到”Sheet2″的”B2″单元格,同上方法双击下去

 

显示不为”#N/A”的为重复.

Excel 办公软件自动集成了“VBA”高级程序语言,用此语言编制出的程序就叫“宏”。

“宏”。也可以通过将操作过程录制.你如有兴趣可点”工具”>”宏”>”录制新宏”试试。

 

来自:http://wenwen.soso.com/z/q172349071.htm

2条评论

  1. hello there and thank you for your information I’ve certainly picked up something new from right here. I did however expertise several technical issues using this website, since I experienced to reload the website many times previous to I could get it to load correctly. I had been wondering if your web host is OK? Not that I am complaining, but slow loading instances times will sometimes affect your placement in google and can damage your high-quality score if ads and marketing with Adwords. Well I am adding this RSS to my e-mail and can look out for much more of your respective exciting content. Ensure that you update this again soon..
    michael kors outlet tanger http://www.sactrustattorneys.com/testimonials/michael-kors-outlet-tanger.html

  2. I like this internet site because so a lot useful material on here : D.
    michael kors ring sale http://www.theabeauty.net/mk/michael-kors-ring-sale.html

发表评论

电子邮件地址不会被公开。 必填项已用*标注