I have a report pulled from our POS system that has anywhere between 1500 to 2500 rows of data. In one of the columns I have a list of groups. Each group may be listed several times as we have only 50 or so total groups. What I need to do is to find out how many groups are listed in total regardless of how many times each group is represented, just how many total groups at the end of the report. I am looking for a VBA answer rather than a formula as this report is pulled up to 3 times every week and I have code already to prepare the report. Any suggestions would be appreciated.