Pulling multiple values of one column into a count structure with multiple counts

Question

I am looking to pull multiple counts into a mini-chart from a column with multiple values. I am trying to do it with one formula. It would end up looking something like this:

ZIP codes	Count
11238	4
46260	2
30201	1

Is there any way to make this with one formula? Thanks for the help!

Answer 1

To be complete, you can use the count() operator and group by predicate in your QUERY statement to count occurrences of a column.

Sample:

Using =QUERY(A1:B6,"select A,count(B) group by A",1)

References:

QUERY()

Query Language Reference