One record per person and that record would be the subject with the most classes per ID

[kernal]

CSV FILE

ID SUBJECT CLASS
1 art 100
1 art 101
1 test 500

2 art 501

3 rec 500
3 rec 502
3 rec 504
3 rec 600
3 lan 100
3 craft 100

Results wanted (Just the subject that has top #classes per id)

ID SUBJECT #CLASS
1 art 2

2 art 1

3 rec 4

Help is greatly appreciated.

 

[lbass]

Not sure why you showed "test" in the first set, since you seem to be excluding that top result. Group on ID and then sort descending on class. Place the fields in the group header and suppress the detail section.

If there is some more complex variation, you need to add more explanation.

-LB