ststern45
Well-known Member
- Joined
- Sep 17, 2005
- Messages
- 958
- Office Version
- 365
- 2010
- Platform
- Windows
Hello everyone,
I wanted to ask if there may be an alternative to the Morefunc add-in formula "Uniquevalues"
Using the example below:
The range "PL" contains the items 54, 22, 92, 54, 4, 71, 54, 54, 38, 66, 92, 31 and 4
Where these values above are located in cell range A1:A13.
returns {92;71;66;54;38;31;22;4}
or
returns {4;22;31;38;54;66;71;92}
Thank you in advance!!
SYNTAX :
{=UNIQUEVALUES(Array,Order)}
Can be a range reference (A1:F1500), a calculated array (A1:F500+H1:M500) or a constant array ({12,5;4,2;23,4}). It can contain any data type (numbers, text, boolean or error codes, empty cells). Maximal size : 65 535 items or cells.
The resulting array has only one column, regardless of the shape of the argument.
EXAMPLES :
The range "PL" contains the items 54, 22, 92, 54, 4, 71, 54, 54, 38, 66, 92, 31 and 4.
{=UNIQUEVALUES(PL)} returns {92;71;66;54;38;31;22;4}
{=UNIQUEVALUES(PL,1)} returns {4;22;31;38;54;66;71;92}
The 5 duplicate items of the range are replaced with empty strings put at the end of the returned array.
I wanted to ask if there may be an alternative to the Morefunc add-in formula "Uniquevalues"
Using the example below:
The range "PL" contains the items 54, 22, 92, 54, 4, 71, 54, 54, 38, 66, 92, 31 and 4
Where these values above are located in cell range A1:A13.
returns {92;71;66;54;38;31;22;4}
or
returns {4;22;31;38;54;66;71;92}
Thank you in advance!!
SYNTAX :
{=UNIQUEVALUES(Array,Order)}
Can be a range reference (A1:F1500), a calculated array (A1:F500+H1:M500) or a constant array ({12,5;4,2;23,4}). It can contain any data type (numbers, text, boolean or error codes, empty cells). Maximal size : 65 535 items or cells.
The resulting array has only one column, regardless of the shape of the argument.
EXAMPLES :
The range "PL" contains the items 54, 22, 92, 54, 4, 71, 54, 54, 38, 66, 92, 31 and 4.
{=UNIQUEVALUES(PL)} returns {92;71;66;54;38;31;22;4}
{=UNIQUEVALUES(PL,1)} returns {4;22;31;38;54;66;71;92}
The 5 duplicate items of the range are replaced with empty strings put at the end of the returned array.