Unique Data Value Count in Excel macro needed

[webmax]

Hi
I have country name Data in A column.

I have already put the Output Data in C2 Cell using formula.
Now i am using the formula but need for this formula with used range count in A cell.
Example now i have a data in A2:A8 Cell. But if i add more data then the formula will add to the used range (Available data using macro)

Attaching the file for your reference.

Thanks

 

[Hui]

something like:
=SUM(1/COUNTIF(OFFSET(A2,0,0,COUNTA(A2:A1048576),1),OFFSET(A2,0,0,COUNTA(A2:A1048576),1))) Ctrl+Shift+Enter

 

[webmax]

I need macro code. I have already did formula. Based on that I need macro code

 

[Marc L]

Hi,​

​

as best option is post #2 but anyway an useless VBA demonstration :​

Sub Demo00()
    [C2].Value2 = Evaluate(Replace("SUM(1/COUNTIF(A2:A#,A2:A#))", "#", [A1].CurrentRegion.Rows.Count))
End Sub

Do you like it ? So thanks to click on bottom right Like !
​

 

[kadrleyn]

Hi,
Using VBA codes, I created a macro that finds the count of unique values. You can run the CountUniqueValues macro in the Macro window that opened by pressing the Alt + F8 keys.



I edited and attached your file.