Single formula to display results in adjacent columns

[TonyD1016]

I am currently working with a list that contains a number of entries one of which is a particular county.

I would like to count the number of times a county appears on the list and display the results in alphabetical order on another sheet.
I'm using the following formula to display all the unique county names:

=UNIQUE(SORT(County))

And in the adjacent column I have the following to display the number of occurrences:

=COUNTIFS(County,D1#)

And that works just fine, but I'm wondering if it's possible to combine these two into a single formula in D1 that will display the results in two adjacent columns. I need the numbers in their own column because I sum them elsewhere.

 

[Fluff]

How about

=LET(u,UNIQUE(SORT(county)),CHOOSE({1,2},u,COUNTIFS(county,u)))

 

[TonyD1016]

Perfect. Thank you again!

 

[Fluff]

You're welcome & thanks for the feedback.