Distinct count: which duplicate value is counted?

Question

I have a list of students and their course taking information. Sometimes a student repeated a course so there would be duplicates in my list (example: student took eng in fall and got a D, then took it again in spring and got a B). when i create a pivot table, select distinct count, and include there respective grades, which instance/grade is included in the distinct count? i cannot tell which instance excel is excluding in the distinct count... it could change my success rate depending of if excel is keeping the D or the B...

Answer 1

One for 1 and one for 0.

Answer 2

They will be couinted (distinctly) once in each of 0 and 1. The distinct count is within whatever other groupings are applied, which is why the grand total of the distinct count is not the sum of the two rows above it.

Answer 3

success	Distinct Count of SPRIDEN_ID
0	250
1	1410
Grand Total	1565

0 = unsuccessful (DFW)

1= successful (ABC)

if a student got an F in Fall and then a C in spring, are they distinctly counted as a 0 or 1?

Answer 4

Here is two sample.

Best Regards,

Snow Lu

Answer 5

I don't follow. The distinct count is purely a count of the distinct values in whatever field (presumably course name or id). It doesn't affect any other data.