Hey everyone, I hope someone can help me out with Excel. Currently I track attendance for a webinar I host and have built in pivot tables and formulas to give me attendance by team, person and so forth. The pain point is that I manually have to enter the data if someone attended or didn't. I'd like to match the email address within the webex report I run (either from it's workbook, or pasting into my tracker's worksheet), to a person's email in column C of my tracker, and then output an "X" if it matches or a "." if it doesn't in a specific cell.
So lets say [email protected] is in cell A10 of the webex report, but [email protected] is in cell C15 of my tracker. I'd then like to output an "X" into cell AT15 of my tracker since I attended.
Any help will be greatly appreciated.
Bookmarks