With your reference numbers in column A and test results in column B use this
in column C

=IF(SUMPRODUCT(--($A$2:$A$500=A3),--($B$2:$B$500="Pass"))0,"Delete","Keep")

Then you can filter on column C and delete the ones that say Delete


"Cath" wrote:

Hi

I am using Excel 2003 and have a data list displaying Reference Numbers and
Test Results.

If reference numbers fail a test they will be retested until they finally
pass the test, therefore there are multiple records for these reference
number.

Once the reference number has PASSED I want to delete ALL (Pass and
Fails)occurences of this reference number.

Any ideas?

Very grateful for any suggestions.
--
Thanks
Cath