Hi

I've been tearing my hair out a bit with this one. I've got a set of data, which I'm applying filters to, but I then need to be able to quickly see how many unique values there are in a given column and the count of each.

My initial plan was a VBA macro, assigned to a button, which would then display a message box with the data. This seemed fine but the feature set of VBA in Zoho seems to be reduced and I'm not able to use a dictionary for this (happy to be corrected!)?

Using nested loops and arrays was also starting to go beyond my VBA capabilities. 

Hoping someone out there has had a similar issue which they managed to solve

Many Thanks, Rich