Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 As you can see find each cell in range R8:R1000 and the grab value in column C and put all duplicates in column s for each P1 in the range the results are 2,4,5 for each duplicate. c d ....... r s (results) 2 P1 2,4,5 3 P2 3 12 P5 12,13 13 P5 12,13 4 P1 2,4,5 5 P1 2,4,5 10 P22 10 Any help would be great! and "Go Wings" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
concatenate 2 columns (A2+B2) and compare for duplicates | Excel Discussion (Misc queries) | |||
find duplicates and concatenate | Excel Worksheet Functions | |||
find duplicates and concatenate | Excel Worksheet Functions | |||
Concatenate with no duplicates | Excel Discussion (Misc queries) | |||
Find Duplicates & Concatenate (cpm) | Excel Discussion (Misc queries) |