This ain’t office hours

What the hell are folks talking about itt with Python or VBA

Just do a Pivot Table and put a Count of Cavity Filling in the fields section

i sorted the work type to show "cavity fillings" because there was different types of work_types

Or filter and do a =SUBTOTAL

Or literally just =COUNTIF

Something like COUNTIF(D1:D200,”I2”)

You can sort by both the patient id and work_types my guy

do you fw teyana taylor @op

Lmao niggas trying to make this a lot more complicated than it is

i did that, i just need to show how much each patient had a cavity filling

Python guy lives in the UK so they’re just a lil weird like that

Sorry they did u like this op

Get the f*** out of excel and use SQL

ive used sql once

just count manually

If you have access to the database it’s just a SELECT DISTINCT patient_id, Count(patient_id) FROM TableName WHERE work_type = ‘Cavity Filling’

alright im doing the pivot table

i put patient_ID in the row field and the Count of work type in the Values. I filtered the worktype to show only cavity fillings and its showing all the work types still

Show us the fields menu

Did you refresh the Pivot Table

lmao op posted a HIPPA violation

Put work_type in Filters as well, then filter for Cavity Filling on the Pivot Table. Not the actual table. Should work then.

Wouldn't pivot table do that for you

now it looks like this. What do i click to filter the cavity filling on the pivot table? The count of work type values are wrong

actually nvm its correct now thanks

i thought I was the only one who noticed

what does this even mean