Excel Magic Trick 1122

Repeat Row Headers Vertically For Each Day Activity Exists: Array Formula

DESCRIPTION

1. Excel 2010 or later formula when day is indicated with the number 1
2. Formula Excel 2010 or later formula when day is indicated with the number 1 or an “x”
3. Excel 2007 or earlier formula when day is indicated with the number 1

WORKBOOKS