Fill combo box with column entries

  • Thread starter Thread starter Johnnyb
  • Start date Start date
J

Johnnyb

I am trying to fill a combo box with company names from a column 'A'. I
it possile to add all of these companies to a combo box removin
duplicates
 
Hi
if your list is in A1:A10 use the following formulas first
to create a helper column:
B1:
=A1

B2: Enter the array formula:
=IF(ISERROR(INDEX($A$1:$A$10,MATCH(0,COUNTIF
($B$1:$B1,$A$1:$A$10),0))),"",INDEX($A$1:$A$10,MATCH
(0,COUNTIF($B$1:$B1,$A$1:$A$10),0)))

Copy this formula down.

Now use this helper column for your data validation listbox
 
Hey Frank,
Thanx for that but I can't seem to get it to work. I have put in cel
B1, "=A1". Then in B2 I have entered the formula and copied it down t
B10. The cells remain blank. Is there anything I am missing?

Regard's,

Johnny
 
Got it, was entering the formula and pressing return, instead of shift
ctrl & return. Cheers Frank.

Regards,

Johnny
 
Back
Top