我有一个excel函数,如下所示- IF(B3="","",IF(AND(G3="NA",F3="Qualified"),"New to Qualified",
IF(AND(G3="NA",F3<>F3<>"Qualified"),IF(H3="NA","TCV Change",IF(H3<>G3,CONCATENATE("TCV C
我曾尝试在VBA中创建一个用户定义的函数,该函数对某个范围内的唯一值进行计数;因此,我使用Excel-function方法作为其基础。Excel函数如下所示: {= SUM(1/COUNTIF(range,range))} 因此,我尝试在VBA中复制它,如下所示: Public Function f_COUNTDISTINCT(我怀疑这是因为我需要告诉VBA