JTL9161
Well-known Member
- Joined
- Aug 29, 2012
- Messages
- 606
- Office Version
- 365
- Platform
- Windows
I have 40 rows in a column "A". The first 20 rows have scores from rounds of golf that I am using to figure out handicaps. I need to extract all of the 20 scores, but when a 21st score is added to the 21st row I delete the score in row 1, so now the 20 scores are from row 2 to row 21. The following week, I add a score to row 22 and remove a score from row 2 making the 20 scores in row 3 to 22. I need a filter (I think) to always extract the 20 posted scores from the column even as I add to the bottom and remove from the top row. I need those 20 scores to show up in column B so I can use the formula to calculate the handicap. Below I will try to show you what I am looking for. I used low numbers to be less confusing
Week 1 there are these 20 scores, score 1 is on row 1 and score 20 is on row 20.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Week 2, score 1 is removed from row 1 and a new score is added to row 21
row 1 is now blank
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
As the 20 scores move down the column, I need to always extract the 20 scores from whatever line they start on to the line 20 rows down. Row 1 to row 20, then next week row 2 to row 21, then row 3 to row 22.
Hope this is not confusing.
Amy help will be appreciated.
James
Week 1 there are these 20 scores, score 1 is on row 1 and score 20 is on row 20.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Week 2, score 1 is removed from row 1 and a new score is added to row 21
row 1 is now blank
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
As the 20 scores move down the column, I need to always extract the 20 scores from whatever line they start on to the line 20 rows down. Row 1 to row 20, then next week row 2 to row 21, then row 3 to row 22.
Hope this is not confusing.
Amy help will be appreciated.
James
