Concatenate multiple rows if condition is met

**kikijean** · 06-10-2022, 07:04 PM

Hello,

I'm hoping there is a formula I can use to accomplish my need. I have a list of numbers in column A, and an associated Reference number in column B. If the number in column A is duplicated in multiple rows, I need the reference numbers in column B to concatenate into a single field in column C.

Sample data attached.
Cells A5 and A6 have the same Lot Number (53). So I need the reference numbers in Cell B5 (CID3121300038) and Cell B6 (CID3121300039) to concatenate in C5 (CID3121300038, CID3121300039).

**TMS** · 06-10-2022, 07:24 PM

Try:

Formula:

Please Login or Register  to view this content.

copied down

**TMS** · 06-11-2022, 03:36 AM

This thread has been marked solved. Is that it? No comment? No feedback? No thankyou? No +rep? Nothing? Makes it all worth while

**wk9128** · 06-11-2022, 04:02 AM

Very bad, didn't say anything, the sign has been resolved, You feel bad when you encounter this situation, You will ignore him or her next time you meet him or her. me too

This link is the same, Infected like a popular wind , helpless and powerless
https://www.excelforum.com/excel-for...roblem-is.html

**TMS** · 06-11-2022, 06:20 AM

You will ignore him or her next time you meet him or her. me too

Oh, yes. I will definitely be avoiding/ignoring any future threads from kikijean. 20 minutes for a resolution and no response. Not happy.

**kikijean** · 06-11-2022, 09:46 AM

I did immediately reply to say that was the perfect solution, appreciate the prompt reply and was very thankful. I'm sorry I must not have posted the reply properly before I closed the Thread. I was really trying to follow the guidelines. Thank you for your help!

**TMS** · 06-11-2022, 10:03 AM

Ok, you're welcome. Maybe review the thread when you close it next time

**wk9128** · 06-11-2022, 10:08 AM

@kikijean welcome back to the forum, nice to see you again

Concatenate multiple rows if condition is met

LinkBack

Thread Tools

Rate This Thread

Display

Concatenate multiple rows if condition is met

Re: Concatenate multiple rows if condition is met

Re: Concatenate multiple rows if condition is met

Re: Concatenate multiple rows if condition is met

Re: Concatenate multiple rows if condition is met

Re: Concatenate multiple rows if condition is met

Re: Concatenate multiple rows if condition is met

Re: Concatenate multiple rows if condition is met

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Concatenate Multiple Cell Values if Condition Is Met

[SOLVED] Concatenate multiple rows into one cell across multiple columns

Concatenate 2 rows but multiple columns - Is this possible?

[SOLVED] Concatenate Multiple Rows Into One Row

[SOLVED] Need to concatenate multiple cells if a condition is met

Concatenate multiple rows and columns into 1 cell

Concatenate text strings from column using multiple criteria condition (formula)

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions