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

"Hitesh Pandya" <Hitesh wrote in message
...
How to find Unique number in a signal column in excel