Difference between revisions of "Manuals/calci/UNIQUESET"

From ZCubes Wiki
Jump to navigation Jump to search
 
Line 40: Line 40:
 
|12
 
|12
 
|}
 
|}
 +
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|v=7fYlWeMQ6L8&t=80s|280|center|Unique}}
  
 
==See Also==
 
==See Also==

Latest revision as of 14: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