Difference between revisions of "Manuals/calci/UNIQUESET"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "UNIQUESET")
 
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
UNIQUESET
+
<div style="font-size:30px">''' UNIQUESET()'''</div><br/>
 +
 
 +
==Description==
 +
*This function returns Unique value from the given set of numbers.
 +
*In <math>UNIQUESET()</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.
 +
 
 +
==Examples==
 +
#UNIQUESET([1,4,2,5,6],[2,10,45,6,1])
 +
{| class="wikitable"
 +
|+Spreadsheet
 +
|-
 +
|1
 +
|-
 +
|4
 +
|-
 +
|2
 +
|-
 +
|5
 +
|-
 +
|6
 +
|-
 +
|10
 +
|-
 +
|45
 +
|}
 +
#UNIQUESET([10,23,14],[14,19,10],[10,12])
 +
{| class="wikitable"
 +
|+Spreadsheet
 +
|-
 +
|10
 +
|-
 +
|23
 +
|-
 +
|14
 +
|-
 +
|19
 +
|-
 +
|12
 +
|}
 +
 
 +
 
 +
==Related Videos==
 +
 
 +
{{#ev:youtube|v=7fYlWeMQ6L8&t=80s|280|center|Unique}}
 +
 
 +
==See Also==
 +
*[[Manuals/calci/UNIQUE| UNIQUE]]
 +
*[[Manuals/calci/DISTINCT| DISTINCT]]
 +
*[[Manuals/calci/DIFFERENCE| DIFFERENCE]]
 +
 
 +
 
 +
==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:52, 4 February 2019

UNIQUESET()


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.

Examples

  1. UNIQUESET([1,4,2,5,6],[2,10,45,6,1])
Spreadsheet
1
4
2
5
6
10
45
  1. UNIQUESET([10,23,14],[14,19,10],[10,12])
Spreadsheet
10
23
14
19
12


Related Videos

Unique

See Also


References

Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/UNIQUESET&oldid=211696"