F
fslost
Hello,
I would like to know if it is possible copy the data in excel column to
variable using the autofilter. I have a huge amount of data repeated in
column, like:
18189
18189
18189
18189
18189
...
18190
18190
18190
18190
18190
...
18191
18191
...
And I just want the single data, without repetition, like:
18189
18190
18191
...
I know that it could be done with a "for" cicle, but it takes a lot of tim
running, because the excel sheet have around of 60 000 lines of data.
So, the autofilter gives me the data without repetition right? can I get acces
to that data and save them to a variable?
Thanks so much for helping.
I would like to know if it is possible copy the data in excel column to
variable using the autofilter. I have a huge amount of data repeated in
column, like:
18189
18189
18189
18189
18189
...
18190
18190
18190
18190
18190
...
18191
18191
...
And I just want the single data, without repetition, like:
18189
18190
18191
...
I know that it could be done with a "for" cicle, but it takes a lot of tim
running, because the excel sheet have around of 60 000 lines of data.
So, the autofilter gives me the data without repetition right? can I get acces
to that data and save them to a variable?
Thanks so much for helping.