I'm trying to automate a spreadsheet that will display a Weekend Duty Roster.
Besides "DATE", I've got 3 Columns:
- Tech 1
- Tech 2
Each column has a list of names. Each list has a different number of people. There are more Coordinators than Techs ... e.g.- Techs are On Call more often than Coordinators.
I know I can put the 3 lists on a seperate page, and reference them somehow with formulas. But how can I create formulas that automatically "know" how long each list is, and adjust if names are added/deleted?