请求VBA代码高手,EXCEL函数公式高手,解决表格数据处理难题,问题描述...答:造了一个公式:=SUM(IFERROR(1/COUNTIF(OFFSET(F2,,,INDEX(FREQUENCY(ROW(A$2:A$14),IF(A$2:A$13<>"",ROW(A$2:A$13))),COUNTA(A$2:A2)+1,0),7),N(OFFSET(F2,ROW(INDIRECT("1:"&INDEX(FREQUENCY(ROW(A2:A14),IF(A$2:A$13<>"",ROW(A$2:A$13))),COUNTA(A$2:...
谁帮忙优化一下vba代码,excel表格数据有3万行,要执行很长一段时间...答:1)=Cells(num, j)Cells(num, 2)=Cells(num, m)Else ' 不明白第J列和K列是数字还是文字,如果是数据,就直接用减号,不需要用&,也不要""Cells(num, 1) = Cells(num, j) & "-" & Cells(num, k)Cells(num, 2)=Cells(num, n)End If Next Application.ScreenUpdating = True ...