My spreadsheet contains a range of cells with dates. They are in random order and there are duplicates
I want to use this range in a listbox on a userform. But I want to prevent it showing duplicates and preferably would have the dates ordered from old to new.
I am trying to do this by copying the data elsewhere, sorting and then removing duplicates, but I guess there must be a more elegant way to do this.
Anybody any suggestions?![Smile :-) :-)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
I want to use this range in a listbox on a userform. But I want to prevent it showing duplicates and preferably would have the dates ordered from old to new.
I am trying to do this by copying the data elsewhere, sorting and then removing duplicates, but I guess there must be a more elegant way to do this.
Anybody any suggestions?
![Smile :-) :-)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)