COUNTIF函数计算结果有问题!!!
对A列计算,从第二行开始,公式为COUNTIF( A$1:A上行行号, A本行行号 ),如第5行为COUNTIF( A$1:A4, A5 )
结果如下:
1400092838
1400113722 0
1400113721 0
1400117969 0
1400117970 0
51713062000000024318 0
51713062000000000061 1
16551713062000000000066 0
16551713062000000023785 1
16551713062000000000070 2
16551713062000000016441 3
16551713062000000018117 4
16551713062000000013495 5
16551713062000000029901 6
16551713062000000024097 7
16551713062000000022078 8
16551713062000000022179 9
16551713062000000000062 10
16551713062000000000063 11
16551713062000000024319 12
16551713062000000014657 13
16551713062000000024320 14
16551713062000000000067 15
16551713062000000024321 16
16551713062000000024814 17
问题是:列中每个值都是唯一的,为什么会出现>0的结果?
然后我用COUNTIF( A$1:A4, VLOOKUP(A5, A$1:A5, 1,0) ),不直接写单元格编号而用VLOOKUP()来代替,结果又如下:
1400092838
1400113722 0
1400113721 1
1400117969 0
1400117970 0
51713062000000024318 0
51713062000000000061 0
16551713062000000000066 0
16551713062000000023785 0
16551713062000000000070 0
16551713062000000016441 0
16551713062000000018117 0
16551713062000000013495 0
16551713062000000029901 0
16551713062000000024097 7
16551713062000000022078 8
16551713062000000022179 0
16551713062000000000062 0
16551713062000000000063 0
16551713062000000024319 12
16551713062000000014657 0
16551713062000000024320 14
16551713062000000000067 0
16551713062000000024321 16
16551713062000000024814 17
发现有部分行的结果对了,但还有错误,难道VLOOKUP()也有问题??!!