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!!
