ExcelBanter - find duplicates and concatenate

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - find duplicates and concatenate (https://www.excelbanter.com/excel-worksheet-functions/190090-find-duplicates-concatenate.html)

rpick60

find duplicates and concatenate

I am trying to find all duplicates in a range R8:R1000 and then grab
the value in Column C of the the duplicate rows and concatenante them
all to the cell in S of that row

example

c d ....... r s (results)
2 P1 2,4,5
3 P2 3
12

All times are GMT +1. The time now is 11:14 AM.