formula to compose a list of values

[PeSt]

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

 

[Gary''s Student]

See:

http://www.cpearson.com/excel/ListFunctions.aspx

 

[Teethless mama]

=IF(ISERR(SMALL(IF(MATCH(List,List,0)=ROW(INDIRECT("1:"&ROWS(List))),MATCH(List,List,0)),ROWS($1:1))),"",INDEX(List,SMALL(IF(MATCH(List,List,0)=ROW(INDIRECT("1:"&ROWS(List))),MATCH(List,List,0)),ROWS($1:1))))

ctrl+shift+enter, not just enter
copy down