I have a list of 150 assets which are assigned to 20 or so depts. How can I
count the number of assets per dept. In essence counting the number of times
different values reoccur? For example

Asset1 - dept1
asset2 - dept 1
asset3-dept2
asset4-dept2
asset5-dept3

dept1 has 2 assets
dept2 has 2 assets
dept3 has 1 asset

Id like to avoid doing a COUNTIF and having to type each dept name