I am busy working with an assessment report. The problem I am experiencing is
that for each person/record on the spreadsheet there are multiple scores for
the assessment €“ for example John Smith may have 4 completed attempts of the
assessment where he failed 3 times and passed once (the pass mark is 90% or
more) Is there a fast way in which I can filter the data and remove the
multiple entries so that if someone has passed only that score is shown and
if they have failed only that score/status is shown??

I need to clean up the raw data report before I start to pull more data in
from other sources via vlookup..

Any and all help much appreciated