with a macro something like
for each c in selection
if c=yournumber then mylist=mylist&","&c
next c
msgbox mylist
--
Don Guillett
SalesAid Software

"cchristensen" wrote in message
...
I have a list of contract numbers (column A) and associated account
numbers
(column B). Some contract numbers are listed more than once because there
may be multiple associated account numbers.

My goal is to have one row/record for each contract number, with all the
associated account numbers in a single cell, comma delimited.

Can Excel do this?