Looping through rows of a column to find the overall countTrying to find the number of counts of current entry in a column. The below function works but seems to be slow. Any suggestions to improve the script run time?
JMP14, JMP16
My proposal: I think initially constructing Associative Array by adding the entries from the :ColName as "Key" and increasing the value (Value++) when duplicate entry i.e. duplicate Key or if it's a new entry, adding a separate Key with value set to 1 would be a better way. Then you can just loop through rows to find the number of "Value" for it.
Automation and Scripting