Hi - I play chess for the Bristol league and unfortunately the league still use a rudimentary excel sheet to report progress.
1. The sheet can be downloaded from https://www.chessit.co.uk/ - it's called Update.xls
2. If you go to the tab saying "Individual results" you will see that each match...
I play Chess for the Bristol League. Now, the results are reported in a really weird way - see "Individual Results" sheet in the attached workbook.
I want to automatically create array names for each table on this sheet so that I can reference these tables later in formulas. Any help?!
I stumbled upon this idea of a new kind of pie chart
Lets say we have 4 categories of expenses:
Home, Children, Entertainment, College
Within these categories we have expenses as follows
Home -> Rent, Furniture, Supplies, Groceries
Children -> Books, Uniforms, Stationery...
I have created a dynamic table.
The inputs are Start Date, End Date each in different cells.
Then I calculate the number of 30-day intervals between the two dates.
I have managed to create a dynamic table that spits out two columns depending on the number of intervals -> namely Serial...