ExcelBanter - find Unique number

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - find Unique number (https://www.excelbanter.com/excel-discussion-misc-queries/119790-find-unique-number.html)

Hitesh Pandya

find Unique number

How to find Unique number in a signal column in excel

Biff

find Unique number

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

All times are GMT +1. The time now is 03:37 AM.