| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find Unique number
How to find Unique number in a signal column in excel
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need a unique number to be created per worksheet | Excel Discussion (Misc queries) | |||
| unique order number according to criteria | Excel Worksheet Functions | |||
| to find number of days between 2 dates using vba code in excel | Excel Discussion (Misc queries) | |||
| Match two tables using unique ID number | Excel Discussion (Misc queries) | |||
| How do I sort a column a unique number? | Excel Worksheet Functions | |||
Linear Mode
