Count number of occurrences and return in text

This solution is involved. The formula is at the bottom along with a link to a user defined function called CONCATALL.

This has two helper cells for "Yes" and "No" ... D1:D2.

I could get the counts right, but I couldn't get them in the order and matched as you posted. The below shows what I mean.

Row\Col	A	B	C	D	E	F	G	H
1	Reviewer	Report Issued?	Error Type	Yes	Reviewer	# of Reports	Error types (Issued)	Error Types (Not Issued)
2	Pete	Yes	No error	No	Pete	4	2 No error, 1 Language proficiency requirement	1 Domain grid
3	Pete	No	Domain grid		Will	4	2 No error	1 ID docs, 1 Document envelope
4	Pete	Yes	Language proficiency requirement		Carol	2	1 ID docs	1 Language proficiency requirement
5	Pete	Yes	No error		Sam	1	1 Registration Form incomplete	NONE
6	Will	No	ID docs		Erica	3	1 ID docs, 1 Domain Grid	1 Registration section- Address
7	Will	Yes	No error
8	Will	No	Document envelope
9	Will	Yes	No error
10	Carol	Yes	ID docs
11	Carol	No	Language proficiency requirement
12	Sam	Yes	Registration Form incomplete
13	Erica	No	Registration section- Address
14	Erica	Yes	ID docs
15	Erica	Yes	Domain Grid

The link to the user defined function is here. It is included in the upload as well.
http://www.excelforum.com/tips-and-t...ml#post3096647

I just copied the names and used Remove duplicates column E.

In column F

Formula:

Please Login or Register  to view this content.

The formulas in columns G:H are both array formulas. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

Meggo12,

My last effort tries way too hard. My apologies. This one is simpler.

It uses the same user defined function as before ... CONCATALL.

There is a helper column in column D. It's formula is

Formula:

Please Login or Register  to view this content.

Columns F and G ... names and counts ... are the same as before.

Columns H and I have these two formulas ... still array entered.

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

Row\Col	A	B	C	D	E	F	G	H	I
1	Reviewer	Report Issued?	Error Type			Reviewer	# of Reports	Error types (Issued)	Error Types (Not Issued)
2	Pete	Yes	No error			Pete	4	1 Language proficiency requirement, 2 No error	1 Domain grid
3	Pete	No	Domain grid	1 Domain grid		Will	4	2 No error	1 ID docs, 1 Document envelope
4	Pete	Yes	Language proficiency requirement	1 Language proficiency requirement		Carol	2	1 ID docs	1 Language proficiency requirement
5	Pete	Yes	No error	2 No error		Sam	1	1 Registration Form incomplete	NONE
6	Will	No	ID docs	1 ID docs		Erica	3	1 ID docs, 1 Domain Grid	1 Registration section- Address
7	Will	Yes	No error
8	Will	No	Document envelope	1 Document envelope
9	Will	Yes	No error	2 No error
10	Carol	Yes	ID docs	1 ID docs
11	Carol	No	Language proficiency requirement	1 Language proficiency requirement
12	Sam	Yes	Registration Form incomplete	1 Registration Form incomplete
13	Erica	No	Registration section- Address	1 Registration section- Address
14	Erica	Yes	ID docs	1 ID docs
15	Erica	Yes	Domain Grid	1 Domain Grid