find values and combine in one cell
Hi- My data set consists of project titles and their project codes; not all projects have codes and some have multiple codes: column A / column B Force / sci.2 Cells / bio.5 Oxygen / bio.1 .........../ chem.4 .........../ sci.6 .........../phys.7 Trees Mass / sci.2.5 Problem: In the example above, "Oxygen" has 4 codes; for projects with multiple codes, how can I combine all the associated codes in one cell in column C? This is how the example above should look: column A / column B / column C Cells / bio.5 Oxygen / bio.1 / bio.1, chem.4, sci.6, phys.7 .........../ chem.4 .........../ sci.6 .........../phys.7 Trees Mass / sci.2.5 -Thanks for your help -- marlea ------------------------------------------------------------------------ marlea's Profile: http://www.excelforum.com/member.php...o&userid=26209 View this thread: http://www.excelforum.com/showthread...hreadid=476044 |
All times are GMT +1. The time now is 01:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com