Posted to microsoft.public.excel.misc
|
|
Create list with macro
Thanks.
"JB" wrote:
Sorted list with UDF function:
http://boisgontierjacques.free.fr/fi...oublonsVBA.xls
JB
On 19 sep, 06:17, JB wrote:
Dynamic With formula:
Rng =OffSet(Feuil1!$A$2,,,CountA(Feuil1!$A:$A))
In C2:
=INDEX(Rng,MIN(IF(Rng<"",IF(COUNTIF(C$1:C1,Rng)=0 ,ROW(INDIRECT
("1:"&ROWS(Rng))),ROWS(Rng)))))
Valid with Shift+ctrl+Enter
http://cjoint.com/?jtgonUhisn
JBhttp://boisgontierjacques.free.fr/
On 18 sep, 22:54, David T wrote:
I have a list of items in column A and I need to create a drop down list in
column B that excludes any duplicate data. Does anyone have a macro that
can do this?
Column A Column B
apple {drop down list inserted here}
pears
orange
apple
orange- Masquer le texte des messages précédents -
- Afficher le texte des messages précédents -
|