I did search the forum but haven't found a thread that appears to address this--if I missed it, my apologies.
I'm using Excel 2010 and have 2 worksheets and want to lookup values from Worksheet1 and concatenate data in Worksheet2 Column D into a cell in Worksheet 1. I've been wracking my brain trying to figure this out and thought folks here must have encountered a similar situation.
Constraints:
I am unable to use Morefunc.
I am not proficient in VBA.
Does anyone have any thoughts?
Can you give us some examples?
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Please attach a sample workbook.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Many thanks for your quick replies!
Here is the example spreadsheet. The desired state is to populate column C, Extra Territories, with concatenated values from the values on the Territory worksheet's Extra Territory column B.
Please disregard the column/row references in the OP.
Try this (backup your data first)
Please Login or Register to view this content.
I should point out that the actual spreadsheets will likely grow into a few hundred rows in the Territory worksheet, and a very manageable, much smaller number on the Business worksheet. As it is, one can obviously filter as necessary with as few rows as there are on the Example.xlsx.
Special K, that's beautiful! Much obliged for the code. I will need to fiddle with it a little bit--I love that it sorts the string as well!
You don't have to be proficient in VBA to use this User Defined Function. Copy and paste it into a module in the VBA editor. It is called Concatall. It was written by tigeravatar and shows up frequently on the Forum.Originally Posted by ed_han
This is one way to use it. This formula must be array-entered. Array enter means the formula must be committed by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.Please Login or Register to view this content.Then fill down.Formula:
Please Login or Register to view this content.
Results look like this:
Row\Col Business 1 619, 318, 320, 615, 306, 321, 322, 330 Business 2 355, 345, 148, 139, 140 Business 3 116, 119, 118, 220, 230, 614, 615
Is this what you are wanting?
Edit formula change.
Last edited by FlameRetired; 04-02-2015 at 11:37 AM.
OK, I thought I had this figured out. Wrong.
I can't help thinking I'm missing something really basic here but I'm just not seeing it. A little help, please?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks