I have data with a row length of around 20,005 and want to count the number of unique data in that row.
Can I using VBA to solve my problem?
I’ve tried writing the formula =SUM((A5:A20005<>””)/COUNTIF(A5:A20005;A5:A20005&””)) directly in the worksheet but it ends up hang on my computer
New contributor
Raka Mediadi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.