How do I get the unique patientID to show how much times they got a cavity filling?

For example, patient_ID:30071 had 1 cavity filling. How do i total how much these patients had a cavity filling because the patients have had multiple cavity fillings.

@op embed messed up

fixed

I column is the unique patientID

Not doing your job for you. There's a reason you get paid.

its for school

Aren't you like 25?

Not getting your degree for you. If you got an Excel problem, hit Youtube for it like the rest of us. Or that one website.

Just saying: how do you not know basic computer skills?

Use a COUNTIF

i did use countif but idk the correct formula

Good luck though fr

Use Google?

support.microsoft.com/en-us/office/count-how-often-a-value-occurs-aa1f3067-05c9-44e4-b141-f75bb9bb89bd#:~:text=Use%20the%20COUNTIF%20function%20to,more%20information%2C%20see%20COUNTIF%20function.

i went to google first and ive tried the formules but that s*** not working

Learn vba for excel u could do this in 10 minutes

I'd write a script for u but I haven't used vba in over 5 years

Maybe just do a pivot table and have ID be a row and the total in the formula box

Put this in Python or SQL

go to the bottom drop down theres info about PivotTables

Actually not necessary ahaha

ima try a pivot table

Do a count if and the Column D and then do I2 in ‘’

Why can't you just sort by patient ID?

Do your homework buddy