paulgunther
New Member
- Joined
- Oct 30, 2019
- Messages
- 31
- Office Version
- 365
- Platform
- Windows
I struggled with the header for this question, let me explain:
I need to take 2 long lists of data in adjacent columns that are too long to fit on a page of print and break them up into multiple "shorter" columns adjacent to each other. The number of rows will vary as the list is updated weekly. The example below should help to explain:
I need to take 2 long lists of data in adjacent columns that are too long to fit on a page of print and break them up into multiple "shorter" columns adjacent to each other. The number of rows will vary as the list is updated weekly. The example below should help to explain:
Sunday CP Handicap League 2022.xlsm | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |||
1 | Handicaps as of: | 52 Weeks | Ace Pot | |||||||||||||
2 | 6/19/2022 | (Max Payout) | $0.00 | |||||||||||||
3 | ||||||||||||||||
4 | HCP | Player | HCP | Player | HCP | Player | HCP | Player | HCP | Player | HCP | Player | ||||
5 | -23 | Player 01 | -1 | Player 18 | -9 | Player 35 | -5 | Player 52 | Leader Board | -23 | Player 01 | |||||
6 | -9 | Player 02 | 1 | Player 19 | -23 | Player 36 | -5 | Player 53 | -9 | Player 02 | ||||||
7 | 2 | Player 03 | -7 | Player 20 | -3 | Player 37 | -5 | Player 54 | 7 | Player 48 | 2 | Player 03 | ||||
8 | -16 | Player 04 | -16 | Player 21 | 3 | Player 38 | -6 | Player 55 | 6 | Player 11 | -16 | Player 04 | ||||
9 | -1 | Player 05 | -13 | Player 22 | -24 | Player 39 | 0 | Player 56 | 4 | Player 16 | -1 | Player 05 | ||||
10 | -2 | Player 06 | 0 | Player 23 | 3 | Player 40 | 1 | Player 57 | 4 | Player 28 | -2 | Player 06 | ||||
11 | 2 | Player 07 | 0 | Player 24 | 3 | Player 41 | -12 | Player 58 | 3 | Player 09 | 2 | Player 07 | ||||
12 | -1 | Player 08 | 0 | Player 25 | 1 | Player 42 | -2 | Player 59 | 3 | Player 10 | -1 | Player 08 | ||||
13 | 3 | Player 09 | 3 | Player 26 | -18 | Player 43 | 3 | Player 26 | 3 | Player 09 | ||||||
14 | 3 | Player 10 | -4 | Player 27 | 2 | Player 44 | 3 | Player 38 | 3 | Player 10 | ||||||
15 | 6 | Player 11 | 4 | Player 28 | -3 | Player 45 | 3 | Player 40 | 6 | Player 11 | ||||||
16 | 0 | Player 12 | -6 | Player 29 | -4 | Player 46 | 3 | Player 41 | 0 | Player 12 | ||||||
17 | -12 | Player 13 | 1 | Player 30 | -22 | Player 47 | 3 | Player 49 | -12 | Player 13 | ||||||
18 | -3 | Player 14 | -7 | Player 31 | 7 | Player 48 | 2 | Player 03 | -3 | Player 14 | ||||||
19 | -1 | Player 15 | 1 | Player 32 | 3 | Player 49 | 2 | Player 07 | -1 | Player 15 | ||||||
20 | 4 | Player 16 | -2 | Player 33 | -16 | Player 50 | 2 | Player 44 | 4 | Player 16 | ||||||
21 | -8 | Player 17 | -1 | Player 34 | 1 | Player 51 | -8 | Player 17 | ||||||||
22 | -1 | Player 18 | ||||||||||||||
23 | 1 | Player 19 | ||||||||||||||
24 | -7 | Player 20 | ||||||||||||||
25 | -16 | Player 21 | ||||||||||||||
26 | -13 | Player 22 | ||||||||||||||
27 | 0 | Player 23 | ||||||||||||||
28 | 0 | Player 24 | ||||||||||||||
29 | 0 | Player 25 | ||||||||||||||
30 | 3 | Player 26 | ||||||||||||||
31 | -4 | Player 27 | ||||||||||||||
32 | 4 | Player 28 | ||||||||||||||
33 | -6 | Player 29 | ||||||||||||||
34 | 1 | Player 30 | ||||||||||||||
35 | -7 | Player 31 | ||||||||||||||
36 | 1 | Player 32 | ||||||||||||||
37 | -2 | Player 33 | ||||||||||||||
38 | -1 | Player 34 | ||||||||||||||
39 | -9 | Player 35 | ||||||||||||||
40 | -23 | Player 36 | ||||||||||||||
41 | -3 | Player 37 | ||||||||||||||
42 | 3 | Player 38 | ||||||||||||||
43 | -24 | Player 39 | ||||||||||||||
44 | 3 | Player 40 | ||||||||||||||
45 | 3 | Player 41 | ||||||||||||||
46 | 1 | Player 42 | ||||||||||||||
47 | -18 | Player 43 | ||||||||||||||
48 | 2 | Player 44 | ||||||||||||||
49 | -3 | Player 45 | ||||||||||||||
50 | -4 | Player 46 | ||||||||||||||
51 | -22 | Player 47 | ||||||||||||||
52 | 7 | Player 48 | ||||||||||||||
53 | 3 | Player 49 | ||||||||||||||
54 | -16 | Player 50 | ||||||||||||||
55 | 1 | Player 51 | ||||||||||||||
56 | -5 | Player 52 | ||||||||||||||
57 | -5 | Player 53 | ||||||||||||||
58 | -5 | Player 54 | ||||||||||||||
59 | -6 | Player 55 | ||||||||||||||
60 | 0 | Player 56 | ||||||||||||||
61 | 1 | Player 57 | ||||||||||||||
62 | -12 | Player 58 | ||||||||||||||
63 | -2 | Player 59 | ||||||||||||||
Test |
Cell Formulas | ||
---|---|---|
Range | Formula | |
I2 | I2 | =ROUND(IF(I1<330,I1-(I1*0.1),300),0) |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
I5 | Cell Value | >-1 | text | NO |
G17:G21 | Cell Value | >-1 | text | NO |
G12 | Cell Value | >-1 | text | NO |
G11 | Cell Value | >-1 | text | NO |
G13:G16,G5:G10 | Cell Value | >-1 | text | NO |
E17:E21 | Cell Value | >-1 | text | NO |
E12 | Cell Value | >-1 | text | NO |
E11 | Cell Value | >-1 | text | NO |
E13:E16,E5:E10 | Cell Value | >-1 | text | NO |
A17 | Cell Value | >-1 | text | NO |
A16 | Cell Value | >-1 | text | NO |
A5:A15,A18:A21 | Cell Value | >-1 | text | NO |
A1:A4 | Cell Value | >-1 | text | NO |
I1:I4 | Cell Value | >-1 | text | NO |
C17:C21 | Cell Value | >-1 | text | NO |
C12 | Cell Value | >-1 | text | NO |
C11 | Cell Value | >-1 | text | NO |
C13:C16,C5:C10 | Cell Value | >-1 | text | NO |
C1:C4 | Cell Value | >-1 | text | NO |
I6:I21,A22:A1048576 | Cell Value | >-1 | text | NO |