| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List of Different Cells
In sheet1.range("b:b") I have a list of numbers. Some of the numbers will repeat, some won't. In userform1.combobox1 I want to list all of the different numbers (no repeats) from sheet1.range("b:b"). What is the easiest way to do this? Big Thanks. -- ForSale ------------------------------------------------------------------------ ForSale's Profile: http://www.excelforum.com/member.php...o&userid=11896 View this thread: http://www.excelforum.com/showthread...hreadid=552094 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If adjacent cells both contain a match from a list, they, and 2 more adj. cells are | Excel Worksheet Functions | |||
| Sort a list with cells referring to others cells | Excel Discussion (Misc queries) | |||
| Sorting cells: a list behind the cells do not move with the cell | Excel Discussion (Misc queries) | |||
| Remove empty cells from named list / validation list | Excel Worksheet Functions | |||
| Condensing a list/range with blank cells to a new list/range without blanks | Excel Worksheet Functions | |||
![ForSale[_74_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
