find duplicates and concatenate

R

rpick60

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find duplicates and concatenate 1
find duplicates and concatenate 4
Depedent Dropdown and INDIRECT($P$8) with a twist 4
Duplicate entry in a column/row 14
Count text cells if condition in row is true, over many rows. 0
Unable to display values in 2nd list box from 1st list box selection 2
Conditional Format Formula for finding duplicates in a row 1
Remove Duplicates 5

Top