Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display Unique Values Question
A sample of my data table:
ID HIP A,B,C,D I29 A,C,G I29 Trying to create the following table (For each HIP, string of unique values) HIP ID I29 A,B,C,D,G Is it possible ? Thank you in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display Unique Values Question
Data Text to Columns Comma Delimiter produces this:
129 A B C D 129 A C G Pivot Table Multiple Consolidation Ranges Range: Select the data plus an empty row above. Layout drag Column button from the diagram and replace it with Value. Options: Uncheck sums Part of the pivot table will look like this: A B C D G 2 1 2 1 1 If the A in the pivot table is at D4 then enter at J4 =D4 At K4 enter =CONCATENATE(J4,",",E4) and fill adjacent cell until you get A A,B A,B,C A,B,C,D A,B,C,D,G |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum Values Question | Excel Worksheet Functions | |||
Count of Unique values | Excel Worksheet Functions | |||
Function to count unique values? | Excel Worksheet Functions | |||
counting unique values and matching to quantities | Excel Worksheet Functions | |||
display values in cell | Excel Discussion (Misc queries) |