Get unique values from a column

[MK_2109]

Extract Unique values from a column, from a different sheet.

Is this method from 2020 still the best way to get unique values?

@sourabh

Step 1: Convert range to JSON

B2: =RANGE2JSON(A2:A,A2:A)

@sourabh

Step 3: Split 'em

=SPLIT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(RANGE2JSON(A2:A,A2:A),‘:“null”’,“”),‘"’,“”),“[{”,“”),“}]”,“”),“,”,1)

Get UNIQUE values from a range of data