Forum Discussion
Formulas and Functions,
I am trying to do a spreadsheet that will track statistics from a bowling league. They each player plays 3 games weekly. i can handle if a person misses a week. However, some times they come in late ...
The OFFSET() function may help you. Here you can also enter minus values with the 3rd parameter to create areas that have been shifted x columns to the left. With the 5th parameter you can then determine how many columns are selected.
Unfortunately, more information is missing for a more qualified answer. Maybe you can upload an example as a file here or at another filehoster. Then we can certainly help you better.