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...
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.I mean if in any empty cell you enter the formula =A1+A2 do you see the value or formula?
In general UNQUIE() works with any values
Thank you for your interest. I see the formula only, no values. I read that the Unique function recognises text as well as numbers. My list is formatted as text in order to have the three digits (eg 00x). The first advice I received was to convert into Numbers or General, but this did not help and indeed changes my desired format.