Difference between revisions of "Manuals/calci/UNIQUESET"

From ZCubes Wiki
Jump to navigation Jump to search
Line 40: Line 40:
 
|12
 
|12
 
|}
 
|}
 +
 +
==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 ]]

Revision as of 14:40, 17 May 2017

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

See Also


References