So I need a site workflow to query a list and make a count of column values which are similar. In the example below, there would be 4 instances of 26 and 3 instances of 27. I can then go on and do other things with those numbers. How should this be done?
My ID
26
26
26
26
27
27
27