hi,
I am able to make a drop down form $a$1:$a$4
it would show me something like this

-----V
apple
apple
grape
peach


what I would like to know if I am able to use the array list that excel uses
on its autosort

wich would be exacly the same but with no repetition.

or would I need to make a function that has a sorting augotithm that feels
my own array? and use the array on the drop down.

I worry about the second option because my sheet has 45.000 lines and about
different values 133 that might be slow