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...
??? 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.
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.
If entire sheet is formatted as text, as HansVogelaar said, apply to the cell where your formula is format General. At this moment nothing changes, you need to re-enter the formula. For example, click F2 and Enter on that cell.