Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup function or something like it...
I have a spread sheet that is set-up similar to this:
377004 AA1 377004 BI2 377004 HH6 377008 DFE 377009 AA1 377009 DFE 377025 BI2 377025 CCI I need a function or some VB code that would create a new cell with the code in column A only listed once and then the codes in column B concatenated together (with spaces between each code). It should look something like this: 377004 AA1 BI2 HH6 377008 DFE 377009 AA1 DFE 377025 BI2 CCI Anyone have some ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Function help | Excel Discussion (Misc queries) | |||
Lookup Function Problems | Excel Worksheet Functions | |||
Complicated lookup function | Excel Worksheet Functions | |||
lookup function 1 | Excel Worksheet Functions | |||
How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions |