Copying and Concatenating data in excel based on a value in another column

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Copying and Concatenating data in excel based on a value in another column

10-16-2021, 07:17 AM

p45cal

Windows 10 Copying and Concatenating data in excel based on a value in another column

Office 2019

Expert

Join Date: Apr 2014

Posts: 962

FILTER and TEXTJOIN available to you?

Code:

=TEXTJOIN(" ",TRUE,FILTER(Sheet1!A1:A15,ISNUMBER(MATCH(Sheet1!B1:B15,{1,5,6,9},0)),"Not found"))

the numbers 1,5,6,9 in a range K7:K10:

Code:

=TEXTJOIN(" ",TRUE,FILTER(Sheet1!A1:A15,ISNUMBER(MATCH(Sheet1!B1:B15,K7:K10,0)),"Not found"))

If this is too simplistic, supply a workbook with what you're wanting rather than a picture of one.

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto populate form (data from excel) in Word based on drop down list selection (data from excel)	wvlls	Word VBA	1	03-22-2019 02:29 PM
Copying data in a column to another column	Peace Freak	Excel	2	04-28-2017 12:31 AM
Extract data based on pattern with respect to specific column	PRA007	Excel Programming	14	12-04-2015 04:32 AM
Help with Macro - copying formula to last line of data based on another column	kidwispa	Excel Programming	1	07-12-2015 05:01 PM
Copying data from Project to Excel	OTPM	Project	13	12-20-2013 10:25 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:03 AM.