add items to listbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top