Greetings!
The project: I have a large set of tables in one tab that is acting as a tracking system for team participation. When a member doesn't show up, I'd like to ask the captains to indicate the missing participant with either a color or italicizing/strikeout.
I would like a list to automatically populate on the next tab, when the captain changes the cell. This way, we have an easy list to view for participants that are consistently not showing up.
For example
(see attached image): Jane, Susan, and Jaime don't show up. The captain(s) go into our excel and mark them absent in some formatting change (bolding, italicizing, etc.). I'd like tab two to then list the actual names "Jane," "Susan," and "Jaime" for the administrators to reference.
Any ideas? I've been trying to work with something like this, but just unsure of how to call out the formatting:
{=INDEX(list,MATCH(0,COUNTIF(uniques,list),0))}
Thank you!
The project: I have a large set of tables in one tab that is acting as a tracking system for team participation. When a member doesn't show up, I'd like to ask the captains to indicate the missing participant with either a color or italicizing/strikeout.
I would like a list to automatically populate on the next tab, when the captain changes the cell. This way, we have an easy list to view for participants that are consistently not showing up.
For example
Any ideas? I've been trying to work with something like this, but just unsure of how to call out the formatting:
{=INDEX(list,MATCH(0,COUNTIF(uniques,list),0))}
Thank you!