Hello,

I looking for a formula or macro to compose automaticaly a list of unique
values based on a worksheet column
for instance

column B
A
A
E
B
E
B
B
C
then list of values is in different cells A and B and C and E

Any idea ?

thanks a lot for your help !

Lapeste