find Unique number

[Hitesh Pandya]

How to find Unique number in a signal column in excel

 

[Biff]

Is this what you want:

A1 = 1
A2 = 1
A3 = 2
A4 = 5
A5 = 5

=INDEX(A1:A5,MATCH(1,FREQUENCY(A1:A5,A1:A5),0))

Returns 2

Biff