page1
Imagine a spreadsheet used to list the members of a non profit organization (or anything else).
(Ok, a database will fit better but in most cases, people just need a simple list…)
What are the problems :
- you can’t know the number of lines (or it will change many times when adding or removing members) ;
- even with subtotals, adding a new line doesn’t duplicate formulas, formatting…
- then you can make mistakes when adding datas.
Some times ago, Excel©™ did solve the problem with a very useful and specific list mode.
1
2
3
4
1. You create your headline on the first line.
2. You create all the formulas, formatting, conditionnal formating… on the second line
3. The magic is when you select the two lines and declare them as a list. The second line becomes the entry line (with * instead of a number line). To add a new member, just fill in the cells and validates. The new line is added just before the entry line with all datas, calculs and formattings.
4. This table could also use dynamic subtotals and sorting/autosorting.
So it was very simple to create a list and modify it at anytime.
= Today - birthdate
= sub-total sum
= Sub-total : number of non empty cells in the column
Indicates the writing line. Still at the end
= if empty / contionnal formatting