Difference between revisions of "Manuals/calci/UNIQUE"
Jump to navigation
Jump to search
(Created page with "UNIQUE") |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | UNIQUE | + | <div style="font-size:30px">''' UNIQUE ()'''</div><br/> |
| + | |||
| + | ==Description== | ||
| + | *This function returns Unique value from the given set of numbers. | ||
| + | *In <math>UNIQUE()</math>, in the parameter the set of non distinct values. | ||
| + | *This function shows the Unique values and removing duplicate values . | ||
| + | *So it is showing a list of unique values. | ||
| + | *Also the displayed unique values in its ascending order. | ||
| + | |||
| + | ==Examples== | ||
| + | #UNIQUE([2,4,8,3,2,10,9,3,5,7,2]) = 2 3 4 5 7 8 9 10 | ||
| + | #UNIQUE([10,10.01,10.001,10,10.01,10,10.001,10.01]) = 10 10.01 10.001 | ||
| + | #UNIQUE([9,4,-9,-4,6,2,-2,-6,9,4,6]) = 2 4 6 9 -9 -4 -2 -6 | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|v=UQUCUhsD3f8&t=25s|280|center|Unique}} | ||
| + | |||
| + | ==See Also== | ||
| + | *[[Manuals/calci/DISTINCT| DISTINCT]] | ||
| + | *[[Manuals/calci/DIFFERENCE| DIFFERENCE]] | ||
| + | *[[Manuals/calci/UNIQUESET| UNIQUESET]] | ||
| + | |||
| + | ==References== | ||
| + | *[https://math.stackexchange.com/questions/220409/definition-of-unique-as-it-relates-to-sets Unique set] | ||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | *[[ Z3 | Z3 home ]] | ||
Latest revision as of 13:51, 4 February 2019
UNIQUE ()
Description
- This function returns Unique value from the given set of numbers.
- In , in the parameter the set of non distinct values.
- This function shows the Unique values and removing duplicate values .
- So it is showing a list of unique values.
- Also the displayed unique values in its ascending order.
, in the parameter the set of non distinct values.Examples
- UNIQUE([2,4,8,3,2,10,9,3,5,7,2]) = 2 3 4 5 7 8 9 10
- UNIQUE([10,10.01,10.001,10,10.01,10,10.001,10.01]) = 10 10.01 10.001
- UNIQUE([9,4,-9,-4,6,2,-2,-6,9,4,6]) = 2 4 6 9 -9 -4 -2 -6