Returning only one row when the person ID is duplicated
SummaryIf a Person ID is on 2 rows, can one of those rows be eliminated from the results based a different field?
If a candidate (Person ID) is listed on 2 or more rows, can the results only show me 1 row based on the earliest date in a different field (Assessment Sent)?
The example picture shows how I would only want the row for Person ID 1623190 with the earliest Assessment Sent date and not the row with a score of 0, but I would still need to keep the row for Person ID 1623830 because I need to know that the assessment was sent but not taken. This means I can't just filter out all of the 0 Assessment Scores.