Forum Discussion
Excel Unique Function
I have Office 365/Windows10-64: In a simple Exel sheet, I have a column of numbers, some duplicated. I want to create a list of unique numbers without the duplicates. In an empty cell, I enter =Un...
Make sure that the number format of the cell has NOT been set to Text. If it is, change the format to General or to Number, then press F2 and Enter.
Thank you for your very fast response. You were right - the numbers were in text format because I need 3 digits, for later use (e.g. 001, 002, 003 etc). Any thoughts on how I keep the three digit format but still get to use the Unique function?
I have changed the first three entries in the column as you said, they are now 1, 1 and 2. However, when I apply the Unique function to this column of three numbers, I still get the formulal as if it was text.
- In addition to the above, I have just entered a column of numbers(formatted as such) with duplicates and then tested the Unique function. No change, I still get the formula as text with no unique list
- ??? I am not sure I understand your question. I have a list of 3 digit numbers, representing an "Owner ID". An owner can own several properties, hence the duplicates in the column of numbers.
The first is 001 in text format, likewise the second, the third is 002 and so on.
I thought that Unique works also with Text.
I wantr to keep the three digit ID's for later use and expansion.. The UNIQUE formula is the only one relating to that array. of ID numbers.
