condensing a list for each category

[carpetony]

In sort of a follow up to the Condensing A List Thread
http://www.mrexcel.com/forum/showthread.php?t=172764&highlight=condense+list

I would like to condense the list into a series of list for each category.

The example below is a synoptic view with some data and does not include the full table.

I would like to do it with functions, i can do it with vb, at this point, I'm more on a mission to do it without it.

TIA:

Book4
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Place	Name	Time	PlacardNumber	Category	CategoryRanking		M39	Name	Time		M40	Name	Time
2	1	Gaines,Jason	0:36:51	25	m39	13		1	???	???		1	???	???
3	2	Forrester,Kevin	0:37:49	24	m40	3		2				2
4	3	Charles,Joel	0:38:47	23	m39	12		3				3
5	4	Loverich,James	0:39:46	22	m39	11		4
6	5	Eppen,John	0:40:41	21	m39	10		5
7	6	Perez,Jucas	0:41:39	20	t	2		6
8	7	Chesterman,Jay	0:42:44	19	m39	9		7
9	8	Dice,Jenn	0:43:35	18	w39	3		8
10	9	Abbot,Roxanne	0:44:34	17	w39	2		9
11	10	Clayton,Trevor	0:45:33	16	mss	3		10
12	11	Limpach,Kevin	0:46:31	15	m39	8		11
13	12	Wilhelm,Anthony	0:47:29	14	m39	7		12
14	13	Hurrocks,Henry	0:48:28	13	mss	2		13
Sheet1

 

[carpetony]

It's greyed out. . .can't select it. . .