Separating Unique Data Instances in a Found Records
I am looking for a function or process that will allow me to separate unique entries amongst found records. For example; I have 1000 records that all have a field "color". I want to be able to have a list of how many unique colors are in the set as well as how many of each color.
Any guidance is much appreciated.