Let's say i have a range of data A1:A10. I have a Userform with Combobox. I would like to fill in combobox with unique values and sort data in combobox by number of times appearing in range. For example:
John, Dave, Liz, Liz, John, Liz would come up in combobox in following sequence: Liz, John, Dave, becouse Liz is mentioned 3 times, John is 2 times and Dave once. I do not want to use new spreadsheet. Any ideas?
Thanks
Bookmarks