| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to list/combine this data?
I've got a spreadsheet set up like this:
Col A: Col B: Bob M10767 Carol C216 Bob Z2196 Jeff D7534 Bob D7535 If I make a list of all of the criteria in Column A, is there a formula that will concatenate all of Column B's information into one cell? Something like this: Bob M10767, Z2196, D7535 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation in Excel 2000 - Can 2 items from a list be combine | Excel Discussion (Misc queries) | |||
| Combine Formula and Data Validation List in a Single Cell ?? | Excel Worksheet Functions | |||
| How can I combine data from a list? | Excel Discussion (Misc queries) | |||
| How do I combine tabulated data into a single column and list alphabetically? | Excel Discussion (Misc queries) | |||
| How can I combine 3 separate mailing list? | New Users to Excel | |||
Threaded Mode
