Detecting unique values

[Joe Shaer]

Dear all,

I am working with a large data-set and need to find any duplicated values under a specific criteria.

I have two columns: 'Direction' and 'Assigned Number'.

Each direction is given an assigned number which can be repeated only in that direction but not in the opposite direction.

For example:
The EB (eastbound) has the number '100' and is repeated only in that direction.

I want to be able to search through the data to see if '100' is repeated in the WB and delete that row. Is there a function or a technique to do this?

I am attaching a sample.

 

[p45cal]

Test the following:
In cell C3 (leave C2 blank):
=IFERROR(IF(INDEX(A$2:A2,MATCH(B3,B$2:B2,0))<>A3,"delete",""),"")
and copy down.
It assumes the uppermost value in the list is the correct value.

 

[Peter Bartholomew]

Using 365

= FILTER(list, XLOOKUP(Number,Number,Direction) = Direction)

 

[vletm]

Joe Shaer​

Your thread's title is Detecting unique values.
You writing asks something else
I want to be able to search through the data to see if '100' is repeated in the WB and delete that row.
Is there a function or a technique to do this?
Without new columns, this would be possible with VBA.
Your thread has opened in Ask an Excel question.
Do You would like to get that kind of sample?