| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
add items to listbox
Hi,
I have a list of name on A1:A70. I assigned 30 random names from that list to C1:C20 array.But I want to add remaining 40 names to a list box to see what are the names not yet assigned. Any help will be greatly appreciated. Thanks in advance -- Regards, Baha |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
add items to listbox
Long time with no reply to what appears to be a relatively easy solution:
In B1 (or another unused cell on row 1) put this formula: =IF(ISNA(MATCH(A1,C$1:C$20,0)),"Unused","") and fill the formula down to B70. The unused names will be indicated. "Baha" wrote: Hi, I have a list of name on A1:A70. I assigned 30 random names from that list to C1:C20 array.But I want to add remaining 40 names to a list box to see what are the names not yet assigned. Any help will be greatly appreciated. Thanks in advance -- Regards, Baha |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to drag items within listbox | Excel Discussion (Misc queries) | |||
| Edit listbox Items | Excel Programming | |||
| How to display Items in ListBox | Excel Programming | |||
| Adding Items to a ListBox-Unique Items Only | Excel Programming | |||
| Items in a Listbox | Excel Programming | |||
Linear Mode
