Ravi Sir's Cards › Excel
Habit Tracker in Excel (card 2 of 2)
Revision card 2 for Habit Tracker in Excel: Goal reached?: =IF(AH5>=B5,"Yes","Not yet") gives Not yet; Habits kept on day 1: =COUNTIF(C5:C9,TRUE) gives 4; Best habit: =INDEX(A5:A9,MATCH(MAX(AH5:AH9),AH5:AH9,0)) gives Drink 8 glasses of water. Includes an example data table.
Read card text
What this card says
2 for Habit Tracker in Excel: Goal reached?: =IF(AH5>=B5,"Yes","Not yet") gives Not yet
Habits kept on day 1: =COUNTIF(C5:C9,TRUE) gives 4
Best habit: =INDEX(A5:A9,MATCH(MAX(AH5:AH9),AH5:AH9,0)) gives Drink 8 glasses of water. Includes an
Example
data table
Learn this in the lesson: How to Make a Habit Tracker in Excel with Checkboxes (Monthly Grid, Totals and Streaks)