Forum Discussion
Solved
Time Sheet
[ Spoiler ]
=INDEX($B$3:$H$3,SMALL(IF(B4:H4="x",COLUMN(A:G)),1))=INDEX($B$3:$H$3,LARGE(IF(B4:H4="x",COLUMN(A:G)),1)+1)For the names along with the start and end time you can apply these formulas. Enter the formulas with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
=INDEX($B$3:$H$3,SMALL(IF(B4:H4="x",COLUMN(A:G)),1))=INDEX($B$3:$H$3,LARGE(IF(B4:H4="x",COLUMN(A:G)),1)+1)For the names along with the start and end time you can apply these formulas. Enter the formulas with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
Thank you, that is what I needed.