Combining similar cell contents into a third cell, but only if they match

**Dvinc76** · 10-05-2016, 03:51 PM

Hello gurus,
I was hoping that someone could help me with a formula. I searched for similar issues but am unable to make the solutions work to my advantage.

Please see attached workbook if it helps. I need to combine the answers given in A2: A6 (dropdowns), and put the corresponding text for that answer into cells E4-E6 respectively.

In effect summarizing what I liked best, middle and least. I can’t figure out t the nested formula that I will need.
I’s appreciate some insight if you can share it.

Hello gurus.jpg

Thanks,
Daniel

**Tony Valko** · 10-05-2016, 03:57 PM

Are you able/open to using a VBA function?

**Dvinc76** · 10-05-2016, 04:02 PM

Hello Tony, not against it but my macro skills have withered. A formula might be easier.

**Tony Valko** · 10-05-2016, 04:26 PM

This VBA function makes it a whole lot easier.

Copy the VBA code at this link and paste it into a general module:

https://www.excelforum.com/showthread.php?p=3096647

Then...

Data Range

	A	B	C	D	E
1	------	------	------	------	------
2	1	Red		1	Red, Blue
3	1	Blue		2	Yellow
4	2	Yellow		3	Purple, Orange
5	3	Purple
6	3	Orange

This array formula** entered in E2 and copied down:

=concatall(IF(A$2:A$6=D2,B$2:B$6,""),", ")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

**Dvinc76** · 10-05-2016, 05:05 PM

Thanks, Tony. I did as you suggested, but no cigar. I put the cod ein to a General tab in 'workbook', if that matters. Should it be in the individual tab's?

Sorry for the newby questions.

Thanks again,

Daniel

**Tony Valko** · 10-05-2016, 05:32 PM

You put the code in the wrong place.

I moved it to the correct location. To see where it is...

ALT F11 will open the VB editor.

In the Project Explorer pane locate the file name and under it you'll see Module 1.

Here's the file.

Combining similar cell contents into a third cell, but only if they match

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Combining similar cell contents into a third cell, but only if they match

Re: Combining similar cell contents into a third cell, but only if they match

Re: Combining similar cell contents into a third cell, but only if they match

Re: Combining similar cell contents into a third cell, but only if they match

Re: Combining similar cell contents into a third cell, but only if they match

Re: Combining similar cell contents into a third cell, but only if they match

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] match cell contents using IF, AND to bring in cell contents from another cell in same row

combining cell contents

insert multiple cells in row if contents of one cell do not match contents of another

Combining cell contents

delete cell contents with find and replace (or something similar)

Combining a range of cells' contents into 1 cell

Comparing contents in a similar (but not exact) cell

[SOLVED] Combining cell contents when there is content to combine

Bookmarks

Bookmarks

Posting Permissions