| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding multiple data values in a column
I have a set of data with Account Name in column A, and related values in
Column B, comma separated. Is there an easy way to find all the unique values in Column B and associate an account name to them? For instance, Row 1 has "Account A" in column A, and "Issue 1, Issue 2" in column B". Row 2 has "Account B" in column A, and "Issue 2, Issue 3" in column B. I'd like transpose, and get a list that says: Issue 1 Account A Issue 2 Account A, Account B etc. VLOOKUP doesn't work, since it returns only a single value. Would an array version work? Thanks, Pete |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding multiple data values in a column
|
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding multiple data values in a column
Awesome Herbert, exactly what I was looking for.
Thanks. Pete "Herbert Seidenberg" wrote: Excel 2007 Tables Advanced Transpose http://www.mediafire.com/file/tti12omn5g2/09_15_09.xlsx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding multiple non-zero values in a column | Excel Worksheet Functions | |||
| finding multiple non-zero values in a column | Excel Worksheet Functions | |||
| Adding multiple values in one column based on multiple values of the same value (text) in another column | Excel Discussion (Misc queries) | |||
| Search Column Data and Return Multiple Values across Row | Excel Worksheet Functions | |||
| Finding (Multiple) Highest Values in Column | Excel Worksheet Functions | |||
Hybrid Mode
