I help run a program that has students from all over the world participate.  I recently created a drop down list of universities and cleaned up previous registrations so we now have clean, consistent data for school names.
I would love to create a table that finds all of the unique values in the school name column and then shows how many of those there are thus showing how many students are registered for each school.
I found instructions on how to create a table of all the registered students, but this is definitely not what I want to do.
Does anyone know how to accomplish this?
Thank you!