Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to compose a list of values
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to compose a list of values
=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(IN DIRECT("1:"&ROWS(List))),MATCH(List,List,0)),ROWS( $1:1))))
ctrl+shift+enter, not just enter copy down "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to check against a list of valid values | Excel Worksheet Functions | |||
How do I compose a daily to-do list? | Excel Discussion (Misc queries) | |||
Difficult chart to compose? | Charts and Charting in Excel | |||
lookup a list of values for an array formula | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions |