Dynamic Halfway Point

[CraigWolfenden]

Hello Everyone,

I was hoping someone could help me with what should be a simple problem, I have been racking my brains for a solution I cannot work out.

A have alist which contains a max of 28 names. Some weeks I may have full 28 names other weeks I may only have 14. I would like the spreadsheet to automatically work out the halfway point and mark half the class in group A and the other half in group B.

Does anyone have any idea how I could do this?

 

[FormR]

Hi, here is a formula option that could try:

Excel 2013/2016
	A	B
1	Names	Group
2	Name 1	A
3	Name 2	A
4	Name 3	A
5	Name 4	A
6	Name 5	A
7	Name 6	A
8	Name 7	A
9	Name 8	A
10	Name 9	B
11	Name 10	B
12	Name 11	B
13	Name 12	B
14	Name 13	B
15	Name 14	B
16	Name 15	B
17	Name 16	B
18	Name 17	B
19
20
21
22
23
24
25
26
27
28
29
Sheet1

Cell Formulas
Range	Formula
B2	=IF(A2="","",IF(ROWS(B$2:B2)<=COUNTA($A$2:$A$29)/2,"A","B"))