Many thanks for your help it makes sense and should sort the sorting out! i
will give it a go tommorow at work!!



"Dave Peterson" wrote:

So you want to keep the highest score--whether it's passing or failing?

With the data in A2:Bxxx (headers in row 1)
I'd sort columns A:B by column A in ascending order and column B in descending
order.

Then I'd add a header in C1: Count
In C2:
=countif(a$2:a2,a2)
and drag down.

You'll see 1's for the highest score for each person. And 2, 3, ... for the
duplicate name entries.

Then apply data|Filter|autofilter to column C
and filter to show the values greater than 1.

Delete those visible rows, remove the filter and delete column C.

You may want to copy to a new worksheet first--just in case!

vlookupabyss wrote:

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

--

Dave Peterson