Fill combo box with column entries

[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

 

[Frank Kabel]

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

 

[Johnnyb]

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

 

[Frank Kabel]

Hi
have you entered the formula in B2 as array formula?

 

[Johnnyb]

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

Regards,

Johnny