The other one would have worked for ONE report had you put Report1 in cell
c1 and it would have left a , at the end
glad to help

--
Don Guillett
SalesAid Software

"Marilyn" wrote in message
...
Don, it's your macro that works for me. The other one gives me a bunch of
commas with no values.

Once again Thanks a Bunch

"Don Guillett" wrote:

Sub makelist()
For i = 1 To 3
ms = ""
For Each c In Range("i2:i5")
If Left(c, 7) = "Report" & i Then ms = ms & "," & c.Offset(, 1)
Next c
MsgBox "Report" & i & " " & Right(ms, Len(ms) - 1)
Cells(i, "k").Value = "Report" & i & " " & Right(ms, Len(ms) - 1)
Next i
End Sub

--
Don Guillett
SalesAid Software

"Marilyn" wrote in message
...
I'm in Excel 2003. I have a sheet with the following data:
ColumnA Column B
Reports ID
Report1 53124
Report1 52145
Report3 58216
Report2 58691

I have been trying to create a formula that will give me all of the ID
numbers associated with Report1, Report2, Report3...and separate each
ID
with
a Comma. For example the Results will look like this:

Column C
Report1 53124, 52145

Is there something I can use to achieve this results?

Thanks,