最快的办法是写VBA程序,逐一进行比较,标记出重复的内容。下面是我以前做的一个实例,供你参考:Sub Macro1()Dim nCount As LongDim nRowCount As LongDim nMark As LongDim nCount2 As LongDim nRowCount2 As Long Dim strTem As StringDim strTem2 As StringDim strV As StringDim strV1 As StringDim strV2 As String'
nRowCount = 2000
nRowCount2 = 2000...