AnsweredAssumed Answered

working with duplicate fields and max

Question asked by mlcastellanos on Mar 21, 2018
Latest reply on Mar 22, 2018 by erolst

Greetings folks. I have an exported table with student ID, grade level, name, address, etc. The table contains duplicates and triplicates of student IDs, as student were in program different times of their middle and high school grades (6-12). I want to first select duplicates ids, then select max gradelevel for duplicate/triplicate set. Any suggestions?

 

Thanks I am a newbie.

Outcomes