Ktt will give you life advice/wrong advice and des
The
Oh your whole life up but they won’t help you out with work 😭

If the assignment asks for a sum of total amounts you can also just put the claim_amount in the Values section too for each cavity filling

Y’all love to get in on a thread where BVL takes an L
But the moment he’s TRYING to get a W y’all are silent

If you’re asking if those stats are real, they’re not Lol

Pretty sure you can just use a count if function and make the range be the table id.

Or just do a pivot table and let it count

im just here to tell yall that excel is the devil. You gotta be sick in the head if you enjoy this

They tryna flex lmao

Just like any skill, for some people Excel comes natural to them. I used to charge $1,000 to do their Excel course (ours was online and was an 8-week course) when I was in college. Was making like $4,000 - $6,000 a semester for two years. Knowing Excel obviously helps in the real world as well

You get them people bragging about doing that fancy s*** then get exposed when they need to use excel in the workplace

youre evil

Lmao I did the same thing in college

use chatgpt

this was my first thought also

excelevated.com

You can use Excel's PivotTable feature to get the unique patient IDs and the number of times they got a specific work type. Here are the steps to follow:

Select the data range that includes all the columns (Claim Date, Claim ID, Dentist ID, Patient ID, Claim Amount, Work type).

Go to the "Insert" tab on the ribbon and click on "PivotTable."
In the "Create PivotTable" dialog box, make sure that the data range is correct and select a location for the PivotTable.

In the PivotTable Fields pane, drag the "Patient ID" field to the "Rows" area, and the "Work type" field to the "Columns" area.

Drag the "Claim ID" field to the "Values" area.

In the "Values" area, click on the drop-down arrow next to "Count of Claim ID" and select "Value Field Settings."

In the "Value Field Settings" dialog box, select "Count" under "Summarize value field by."

Click "OK" to close the dialog box.

Now the PivotTable should show the unique patient IDs in the rows, the specific work types in the columns, and the count of Claim IDs in the values area.

To filter the PivotTable to show only a specific work type, click on the drop-down arrow next to the "Work type" field in the "Columns" area and uncheck any work types you don't want to include.

This should give you a table that shows the unique patient IDs and how many times they got a specific work type.

alright guys. Is there a way to make this pivot table look not long? I have to post this table in a word document. The pivot table is 422 cells long vertically.