LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default need assistance with some find or lookup related code...

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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
help needed with lookup and related functions EdStevens Excel Worksheet Functions 3 August 19th 09 10:00 PM
Lookup related question Craig Excel Worksheet Functions 1 June 23rd 09 04:48 PM
Lookup value and return with all related data help_0616 Excel Discussion (Misc queries) 0 July 17th 08 03:46 AM
lookup related with defined name KrunoG Excel Worksheet Functions 0 February 24th 06 01:42 PM
Finding the Max of a related Value Lookup Cav Excel Worksheet Functions 4 November 23rd 05 02:53 PM


All times are GMT +1. The time now is 03:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"