Excel Distinct Count

I have two columns in Excel: Location and MRN:

LOCATION MRN
Peds 125865
Broadway Clinic 125865
Inpatient 12563251
Broadway Clinic 12523652
Broadway Clinic 12523652

I need to count the MRN’s for each location. So, the result I need would look like this:

Broadway Clinic 3
Peds 1
Inpatient 1

Any ideas? Thanks!!