Listing numbers in one cell by person's name

This is better suited for VBA but since you posted in the "Excel Formulas & Functions" section, I'll have a go at it using formulas.

Based on the layout described in post #1 (assuming that the data starts in row 1), you can use this to return all matches:
O1 =IFERROR(INDEX($A:$A,SMALL(IF($C$1:$C$5=$M1,ROW($C$1:$C$5)),COLUMNS($A:A))),"") Ctrl Shift Enter
Drag this formula through Q1 then down through row 5.

Then, in N1, this will combine the matches into a single cell:
=IF(O1="","","Line ")&O1&IF(P1="","",", ")&P1&IF(Q1="","",", ")&Q1
Drag this formula down through row 5.

If you have the TEXTJOIN function (Office 365 subscription or UDF), you can use this scale able formula in N1:
=IF(O1="","","Line ")&TEXTJOIN(",",TRUE,O1:Q1)
Dragged down through row 5.

See attachment for clarification.

Thanks 63falcondude,

This did work, but I should had been more clear with my description as there are in-reality 100~200 lines. In my example I only illustrated 5... and that there maybe more then just two times the name would come up. Ie. Ian "Line 1, 4, 24, 36, 99... etc".

I will mark as solved since your answer does work and move this question to "Excel Formulas & Functions" section as you indicated.

Thanks!

Originally Posted by dflak

This probably would have been easier if I decided to do double loops, one for the names in column M and another for the names in column B. However, I was bound and determined to use the find command and figure out a way to keep it from going back to the top after finding the last occurrence of the name.

Oh Great!
But i'm not sure how this works. There doesn't seem to be a formula that I can move to my spreadsheet.