How do I create a database with a maximum of 20 entries

F

FCPCEO

I am trying to create a spreadsheet in Excel that collects golf scores and
averages them out. How do I set a maximum of 20 entries with the 21st entry
causing the first entry to drop off automatically?
 
S

smartin

FCPCEO said:
I am trying to create a spreadsheet in Excel that collects golf scores and
averages them out. How do I set a maximum of 20 entries with the 21st entry
causing the first entry to drop off automatically?
Click to expand...

I suggest you rethink your approach:

Do not limit the number of entries, but adjust your analysis to examine
the 20 most recent entries. Google "excel rolling average" for more ideas.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
How do I clear a form? 0
Conditiontal linking between spreadsheets 3
Dealing with a Pivot Table (when I don't want to) 0
Dynamic Naming of Form Button 3
Adding a big matrix in Word 2013 5
how do I calculate the total of the lowest 10 numbers in an array 7
How do I remove the top half of a block interval? 1

Top