Show running list of scores

[JTL9161]

I have 20 golf scores. When a new score is added to the bottom of the list, I delete the score on the top of the list. This is a running list of the golfers 20 scores. To calculate a handicap, I need to take those 20 scores from the list, but since it's a running list there will be blank cells at the top of the list as I delete the older score and replace it at the bottom with a new score. I need to extract those 20 scores regardless how many blank cells are at the top of the list. In the list below note the blank cell at the top. In my new listing I need the 47 to be at the top of the list and the 48 in the 20th cell. The next week the 47 gets deleted and the next score (50) moves up to the 1st cell and a new score is added after the 48. When that happens there will now be 2 blank cells at the top and in my new listing, I need the 50 to be at the top of list replacing the 47 and the new score will appear at the bottom.

Any help will be appreciated.
James

47
50
52
53
51
44
44
50
50
51
53
55
50
53
52
58
48
51
48

 

[AhoyNC]

You could turn your list into a table and then use the TAKE function to get the last 20 scores. You would not need to delete the top scores.
Your list only had 19 scores, so I added one to the list.

Book1
	A	B	C
1	Column1		Last 20
2			47
3			50
4	47		52
5	50		53
6	52		51
7	53		44
8	51		44
9	44		50
10	44		50
11	50		51
12	50		53
13	51		55
14	53		50
15	55		53
16	50		52
17	53		58
18	52		48
19	58		51
20	48		48
21	51		55
22	48
23	55
Sheet1

Cell Formulas
Range	Formula
C2:C21	C2	=TAKE(Table1[Column1],-20)
Dynamic array formulas.

 

[JTL9161]

Thank you, I'll give it a try and thank you for understanding my description.

 

[JTL9161]

Ok so I got the column1 labeled but where do I get the Table1 from? For the table I went to the insert tab, Tables, create table. Does that default to name it Table1?


James

 

[AhoyNC]

Excel will give the table a default name. You can change that name if you want. If you had a header to your colimn, such as SCORES the table would use it. If you don't have a header excel will assign one. That's where the the Column1 header came from. Once you add a score to the last row in the table the range will automatical expand.

Here are a couple of links that explain the table and TAKE function.
Table link

TAKE function