Multi-Dimensional concatif coding

Here is another way of doing it...( An array entered formula.. use Ctrl + shift + enter to confirm it.)

Formula:

Please Login or Register  to view this content.

Here is the JoinC Code with will concatenate the results.

Please Login or Register  to view this content.

You didn't provided the Row and Column No. of your output table below.
So I Assumed like this:-

Please Login or Register  to view this content.

Note:- Put the above formula in C2 by using CTRL + SHIFT + ENTER and Drag downwards and Sideways.

Table3.JPG



Here is the link you can find the JoinC Code:-
Concatenating Rows (JoinR) and Columns (JoinC)

Hi Vikas, your function with JoinC comes with an error in value. I did use ctrl Shift Enter to go along with the array data. And when I took out 'INDEX($C$19:$I$30,MATCH(C$1,$B$19:$B$30,0))'.. it results in a reference error. Can you help me out once again?

I recognize the code that I wrote for the ConcatIf function.
It looks like I'll have to write a ConcatIfs function.

It will be easier if I could hard code a delimiter.
While your need is for a comma delimiter, I've seen other coders who need commas in the data. Hmm.....

Upgrading to a ConcatIfs is one of those projects that I've been putting off.
I hope there isn't a rush, since I probably wont have time until the weekend.
If that time scale works for you, great.
If you need it sooner, give it a shot yourself and I can guide you through any problems. If you do it your self, dump the NoDuplicates argument and the If Instr.... line.

Hi WildEye..
I guess, there is a problem with references.
Provide a sample of your workbook, if you can. Then It would a lot easier for me to work upon.

Okay I guess I have been able to achieve it.
Next time, be sure that you provide a sample workbook so that we don't have to create it ourselves.

Here is the revised JoinC code, I have revised it in the post2 as well.

Please Login or Register  to view this content.

Check the attached file:-

Here is the CountIfs UDF that I've developed.
The syntax is =CountIfs(stringsRange, CriteriaRange1, Criteria1, CritereriaRange2, Criteria2,...., [optional Delimiter])

The last argument is and optional delimiter that defaults to space.

Note that any of the ranges can be rectangular, they need not be single column or row ranges.
Note also that if the CriteriaRanges and Criterias are omitted, it will return a delimited string of the values in the StringsRange.

Please Login or Register  to view this content.

EDIT:
The attached is an example workbook