Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenating all records in column b where column a=x
HI :
I have 3 columns of cells: BUILDINGID INHABITANTS 123123 joe 123123 sam 123123 tim 333444 mary 333444 louise 333444 tom 222333 marsha I would like to have a table that has each buildingid only once as a unique record with a second field having a string of the concatenated inhabitants. For instance: buildingid inhabitants 123123 joe sam tim 333444 mary louise tom 222333 marsha How can I create a function that if I give it a chosen buildingid, the name of a range of building ids, and the name of a range of inhabitants, will give me a single record with a concatenated string of all inhabitants that are in records with the chosen building id? Thanks in advance for your help, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extract unique records from one column | Excel Worksheet Functions | |||
Date column changed to number format while concatenating | Excel Discussion (Misc queries) | |||
How to add text to all existing records in one column? | Excel Discussion (Misc queries) | |||
Matching the same amount of records in one value to another column | Excel Worksheet Functions | |||
Deleting specific records from a column | Excel Discussion (Misc queries) |