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

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