Excel Unique Function

Question

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 =Unique(N6:N40) and press ENTERThe cell containing the formula just repeats the formula as if it was text and there is no list at all.I defer to the experts.&nbsp; Thank you.

hansvogelaar · Answer

KevinWheatland&nbsp;
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.

kevinwheatland · Answer

HansVogelaar&nbsp;Thank you for your very fast response.&nbsp; You were right - the numbers were in text format because I need 3 digits, for later use (e.g. 001, 002, 003 etc).&nbsp; 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.&nbsp; However, when I apply the Unique function to this column of three numbers, I still get the formulal as if it was text.

kevinwheatland · Answer

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

sergeibaklan · Answer

KevinWheatland&nbsp;
Is that only for this formula or for any one?

kevinwheatland · Answer

??? 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.

Forum Discussion

Excel Unique Function

8 Replies

Resources