I have a list which has companyname and contracts numbers in column A & B

Example

Company Name Contract Number

AAA 888888
BBB 888088
BBB 888333


What I could like to do is to write a formula or a macro to combine all the
contracts numbers for a company into a single cell

for example

AAA 888888
BBB 888088, 888333

Can this be done?

Thanks

Pls try this formulae in column C =A1&" "&B1

Note : " " is for spacing

Rajkuma

--
Message posted from http://www.ExcelForum.com

Hi

i found this answer from Frank Kabel awhile back and saved it for just such
an occassion -

> one way (this requires VBA):
> - download Alan Beban's array functions: http://home.pacbell.net/beban
> - download the free add-in Morefunc.xll
> (http://longre.free.fr/english/)
>
> Now use the following formula:
> =MCONCAT(VLOOKUPS(DATE(2004,3,17),A1:B100,2,0),", ")
- correct the formula and adjust for your situation
=MCONCAT(VLOOKUPS(D2,$A$1:$B$100,2),", ")
> assuming the date is in column A and the description in column B
and a list of the unique Company Names are in column D starting at row 2
and this formula is entered into column E.

let me know how you go, i had to play around with it for awhile before i
could get it to work.

Cheers
JulieD




"JP SIngh" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have a list which has companyname and contracts numbers in column A & B
>
> Example
>
> Company Name Contract Number
>
> AAA 888888
> BBB 888088
> BBB 888333
>
>
> What I could like to do is to write a formula or a macro to combine all
the
> contracts numbers for a company into a single cell
>
> for example
>
> AAA 888888
> BBB 888088, 888333
>
> Can this be done?
>
> Thanks
>
>