I need to create an attendance report where there is almost 200 participants to record. The spreadsheet I have set up has a tab for attendance data (a list of names who attended in a single column with the date as a header) and a tab for the report. What I would like to do is have a formula on the report tab that looks at the data tab (finding the column for the matching date) and put the word "There" in the row/column next to their name.
I have attached a small sample workbook with a section for the expected results. In the real workbook, I will be creating this report each month and the list of participants will change (along with the number of participants).
Thank you for any assistance you can give me with this.
Cliff
Bookmarks