View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default formula to compose a list of values

See:

http://www.cpearson.com/excel/ListFunctions.aspx
--
Gary''s Student - gsnu2007h


"PeSt" wrote:

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