文章分类 -  Excel

比较a，b两列值，把b not in a中的值，突出显示
摘要：k = 0 For Each x In Sheet1.Range("d1:d13") For Each y In Sheet1.Range("a1:a10") If x.Value = y.Value Then k = k + 1 End If Next If k = 0 Then x.Inter... 阅读全文

posted @ 2005-08-01 14:09 zz 阅读(177) 评论(0) 推荐(0)

导航