warhorse927
New Member
- Joined
- May 18, 2002
- Messages
- 30
Paddy came close to what I needed but I couldn't tweak it enough to return what I need. I have the table below
I need it to display the cohort number(s) beside the number of students. I am completely stumped on this. Help Paddy!!
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
2 | BSMIS | MISM701 | MISE702 | MISE703 | MISE704 | MISE705 | MISE705B | ||
3 | #Students | 11 | 10 | 8 | 8 | 12 | 7 | ||
4 | IDS.345 | 10/5/00 | 2/19/01 | 6/19/01 | 8/20/01 | 2/14/02 | 8/22/02 | ||
5 | BUS.140 | 10/26/00 | 3/12/01 | 7/10/01 | 9/17/01 | 3/7/02 | ######### | ||
6 | MIS.335 | 5/24/01 | 10/1/01 | 1/29/02 | 4/8/02 | 8/15/02 | 9/19/02 | ||
7 | ACC.331 | 7/5/01 | 11/5/01 | 3/5/02 | 5/13/02 | 8/15/02 | 9/19/02 | ||
8 | MIS.240 | 8/9/01 | 12/10/01 | 4/16/02 | 6/24/02 | 8/15/02 | 9/19/02 | ||
9 | MIS.242 | 9/13/01 | 1/28/02 | 5/28/02 | 7/29/02 | 1/23/03 | 1/23/03 | ||
10 | BUS.476 | 10/25/01 | 3/11/02 | 7/9/02 | 9/16/02 | 1/23/03 | 1/23/03 | ||
11 | MIS.350 | 1/24/02 | 6/3/02 | 9/17/02 | 11/25/02 | 1/23/03 | 1/23/03 | ||
12 | MIS.325 | 5/16/02 | 9/23/02 | 1/21/03 | 3/24/03 | 6/26/03 | 6/26/03 | ||
13 | MIS.460 | 6/20/02 | 10/28/02 | 2/25/03 | 5/5/03 | 6/26/03 | 6/26/03 | ||
14 | |||||||||
15 | |||||||||
16 | BeginDate | 9/1/02 | |||||||
17 | EndDate | 9/30/02 | |||||||
18 | |||||||||
19 | Class | Studentsinclass | Cohort(s) | ||||||
20 | IDS.345 | 0 | |||||||
21 | BUS.140 | 0 | |||||||
22 | MIS.335 | 7 | |||||||
23 | ACC.331 | 7 | |||||||
24 | MIS.240 | 7 | |||||||
25 | MIS.242 | 0 | |||||||
26 | BUS.476 | 8 | |||||||
27 | MIS.350 | 8 | |||||||
28 | MIS.325 | 10 | |||||||
29 | MIS.460 | 0 | |||||||
Sheet1 |
I need it to display the cohort number(s) beside the number of students. I am completely stumped on this. Help Paddy!!