Reply
  • Mar 3, 2023

    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.

  • Mar 3, 2023
    ·
    1 reply

    @op embed messed up

  • OP
    Mar 3, 2023
    hoopsplayer21

    @op embed messed up

    fixed

  • OP
    Mar 3, 2023

    I column is the unique patientID

  • Mar 3, 2023
    ·
    2 replies

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

  • OP
    Mar 3, 2023
    ·
    2 replies
    Mountain Dude

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

    its for school

  • Mar 3, 2023
    ·
    1 reply
    BVL

    its for school

    Aren't you like 25?

  • OP
    Mar 3, 2023
    ·
    1 reply
    Mountain Dude

    Aren't you like 25?

  • Mar 3, 2023
    BVL

    its for school

    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.

  • Mar 3, 2023
    BVL

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

  • Mar 3, 2023
    ·
    1 reply

    Use a COUNTIF

  • OP
    Mar 3, 2023
    ·
    1 reply
    2012

    Use a COUNTIF

    i did use countif but idk the correct formula

  • Mar 3, 2023

    Good luck though fr

  • Mar 3, 2023
    ·
    1 reply
    BVL

    i did use countif but idk the correct formula

    Use Google?

  • OP
    Mar 3, 2023
    2012

    Use Google?

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

  • Mar 3, 2023

    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

  • Mar 3, 2023

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

  • Mar 3, 2023
    ·
    1 reply

    Put this in Python or SQL

  • Mar 3, 2023
    ·
    1 reply
    Ron Royalty

    https://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.

    go to the bottom drop down theres info about PivotTables

  • Mar 3, 2023
    Yuzzy

    Put this in Python or SQL

    Actually not necessary ahaha

  • OP
    Mar 3, 2023
    Ron Royalty

    go to the bottom drop down theres info about PivotTables

    ima try a pivot table

  • Mar 3, 2023

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

  • Mar 3, 2023
    ·
    1 reply

    Why can't you just sort by patient ID?

  • Mar 3, 2023

    Do your homework buddy