Storing distinct values in an array

S

shimeel

Hello ..

in the speadsheet, i have a column containing a series of numbers
maybe of them repeated multiple times...

i would like to store all distinct values in an array

any ideas on how i could do that ...

eg , if these were the numbers going down column then 1 3 5 7 5 3 5 7
5 4 3 4 5 7 8 5 3 .. store 1,3,5,7,9,4,8 in an array, in no specifi
order


thank you

shimee
 
A

Aladin Akyurek

Try to run Advanced Filter on your data with the "Unique records onl
option" option checked.
 
F

Frank Kabel

Hi
if you have only numbers try the following two formulas:
B1: = MIN($A$1:$A$10)

B2: = SMALL($A$1:$A$10,1+SUMPRODUCT(COUNTIF($B$1:$B1,
$A$1:$A$10)))



and copy b2 down as far as needed
 
Top