carpetony
New Member
- Joined
- May 26, 2008
- Messages
- 14
- Office Version
- 365
- Platform
- Windows
- Mobile
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:
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 |