Criteria List

[default_name]

Hello all,

It was kind of tricky to come up with the best way to title this thread...my apologies for vagueness.

I have a pretty big spreadsheet with a lot of detailed items.
Rows A:CV are a bunch of details about an item.
Rows CV:DH are a list of categories...if the item meets certain Category characteristics, then it is listed as TRUE.
Basically, the table looks something like this:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B to CV[/TD]
[TD]CW[/TD]
[TD]CX[/TD]
[TD]CY[/TD]
[TD]CZ[/TD]
[TD]DA[/TD]
[TD]DB[/TD]
[TD]DC[/TD]
[TD]DD[/TD]
[TD]DE[/TD]
[TD]DF[/TD]
[TD]DG[/TD]
[TD]DH[/TD]
[TD]DI[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]Category A
[/TD]
[TD]Category B[/TD]
[TD]Category C[/TD]
[TD]Category D[/TD]
[TD]Category E[/TD]
[TD]Category F[/TD]
[TD]Category G[/TD]
[TD]Category H[/TD]
[TD]Category I[/TD]
[TD]Category J[/TD]
[TD]Category K
[/TD]
[TD]Category L[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Item 1[/TD]
[TD]a bunch of details about the item[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Item 2[/TD]
[TD]a bunch of details about the item[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Item 3[/TD]
[TD]a bunch of details about the item[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Item 4[/TD]
[TD]a bunch of details about the item[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Item 5[/TD]
[TD]a bunch of details about the item[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7...
[/TD]
[TD]...thousands of items...[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I am trying to figure out how to break down the results into a list on the same cell...something like this:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B to CV[/TD]
[TD]CW[/TD]
[TD]CX[/TD]
[TD]CY[/TD]
[TD]CZ[/TD]
[TD]DA[/TD]
[TD]DB[/TD]
[TD]DC[/TD]
[TD]DD[/TD]
[TD]DE[/TD]
[TD]DF[/TD]
[TD]DG[/TD]
[TD]DH[/TD]
[TD]DI[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]Category A
[/TD]
[TD]Category B
[/TD]
[TD]Category C
[/TD]
[TD]Category D
[/TD]
[TD]Category E
[/TD]
[TD]Category F
[/TD]
[TD]Category G
[/TD]
[TD]Category H
[/TD]
[TD]Category I
[/TD]
[TD]Category J
[/TD]
[TD]Category K
[/TD]
[TD]Category L
[/TD]
[TD]Possible Categories
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Item 1[/TD]
[TD]a bunch of details about the item[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]Category A, Category D, Category H[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Item 2[/TD]
[TD]a bunch of details about the item[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]Category B, Category C, Category G, Category H, Category I[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Item 3[/TD]
[TD]a bunch of details about the item[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]Category E, Category F, Category J[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Item 4[/TD]
[TD]a bunch of details about the item[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]Category D, Category L[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Item 5[/TD]
[TD]a bunch of details about the item[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]Category A, Category E, Category F, Category I[/TD]
[/TR]
[TR]
[TD]7...[/TD]
[TD]...thousands of items...[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Interpretation: Item 1 belongs Category A, Category D, and Category H.

Hope that makes sense.

Thanks in advance for your help!

 

[Fluff]

It's whether you want a "carriage return" between each value or a coma, see posts 4 & 5

 

[default_name]

Turning on WrapText with the carriage return/NL looks great.
However, I am not able to get the correct results in the all FALSE instances.
See below in red for an example:


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B to CV[/TD]
[TD]CW[/TD]
[TD]CX[/TD]
[TD]CY[/TD]
[TD]CZ[/TD]
[TD]DA[/TD]
[TD]DB[/TD]
[TD]DC[/TD]
[TD]DD[/TD]
[TD]DE[/TD]
[TD]DF[/TD]
[TD]DG[/TD]
[TD]DH[/TD]
[TD]DI[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]Category A
[/TD]
[TD]Category B
[/TD]
[TD]Category C
[/TD]
[TD]Category D
[/TD]
[TD]Category E
[/TD]
[TD]Category F
[/TD]
[TD]Category G
[/TD]
[TD]Category H
[/TD]
[TD]Category I
[/TD]
[TD]Category J
[/TD]
[TD]Category K
[/TD]
[TD]Category L
[/TD]
[TD]Possible Categories
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Item 1[/TD]
[TD]a bunch of details about the item[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]Category A
Category D
Category H
[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Item 2[/TD]
[TD]a bunch of details about the item[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]Category B
Category C
Category G
Category H
Category I
[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Item 3[/TD]
[TD]a bunch of details about the item[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]Category E Category F Category J
[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Item 4[/TD]
[TD]a bunch of details about the item[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]Category D
Category L
[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Item 5[/TD]
[TD]a bunch of details about the item[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]Category A Category E Category F Category I
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]Item 6
[/TD]
[TD]a bunch of details about the item
[/TD]
[TD]FALSE
[/TD]
[TD]FALSE
[/TD]
[TD]FALSE
[/TD]
[TD]FALSE
[/TD]
[TD]FALSE
[/TD]
[TD]FALSE
[/TD]
[TD]FALSE
[/TD]
[TD]FALSE
[/TD]
[TD]FALSE
[/TD]
[TD]FALSE
[/TD]
[TD]FALSE
[/TD]
[TD]FALSE
[/TD]
[TD]#VALUE!
[/TD]
[/TR]
[TR]
[TD]8...
[/TD]
[TD]...thousands of items...[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thanks for your patience and help!
You're great!

 

[Fluff]

Not sure why that doesn't work for you as it works for me

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1			Category A	Category B	Category C	Category D	Category E	Category F	Category G	Category H	Category I	Category J	Category K	Category L
2	Item 1	a bunch of details about the item	TRUE	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	Category A Category D Category H
3	Item 2	a bunch of details about the item	FALSE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE	TRUE	TRUE	FALSE	FALSE	FALSE	Category B Category C Category G Category H Category I
4	Item 3	a bunch of details about the item	FALSE	FALSE	FALSE	FALSE	TRUE	TRUE	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE	Category E Category F Category J
5	Item 4	a bunch of details about the item	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	Category D Category L
6	Item 5	a bunch of details about the item	TRUE	FALSE	FALSE	FALSE	TRUE	TRUE	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	Category A Category E Category F Category I
7	Item 6	a bunch of details about the item	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	NA
Sheet1

Cell Formulas
Range	Formula
O2	=DefaultName(C2:N2,$C$1:$N$1)