Ravi Sir's Cards › Excel
Household Chores Roster in Excel (card 2 of 2)
Revision card 2 for Household Chores Roster in Excel: Chore 2 starts one person later: =INDEX($A$6:$A$9,MOD($C6-1+1,$B$10)+1) gives Shraddha; This week's number: =MATCH(B3,D6:D13,1) gives 3. Includes an example data table.
Read card text
What this card says
2 for Household Chores Roster in Excel: Chore 2 starts one person later: =INDEX($A$6:$A$9,MOD($C6-1+1,$B$10)+1) gives Shraddha
This week's number: =MATCH(B3,D6:D13,1) gives 3. Includes an
Example
data table
Learn this in the lesson: Household Chores Roster in Excel: Rotate Chores Every Week Automatically (INDEX and MOD)