Excel之家ExcelHome以下文章来源于VBA编程学习与实践 ,作者EH看见星光我们今天和大家分享的内容是如何用VBA代码查询两列数据差异。
打个响指,举个栗子。
![d6c4ed4a89122c35893103f5e9600d4e.png](https://img-blog.csdnimg.cn/img_convert/d6c4ed4a89122c35893103f5e9600d4e.png)
如上图所示,查询A列和C列的数据,提取出相同值、A列存在C列不存在的值、A列不存在C列存在的值……
查询结果如下图所示。
![970cebf6dc4f62bbe579443be1cad654.png](https://img-blog.csdnimg.cn/img_convert/970cebf6dc4f62bbe579443be1cad654.png)
当然,这事儿并不是一定得用VBA,函数和Power Query都可以的。
代码如下:
Sub CheckTwoClnData()
Dim d As Object
Dim i As Long, n1 As Long, n2 As Long, n3 As Long, m As Long
Dim strTemp As String
Dim arr1 As Variant, arr2 As Variant, brr As Variant, kr As Variant
Dim rng1 As Range, rng2 As Range, rng As Range
Set d = CreateObject("scripti