P
Paulo
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
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