Hi, first time poster. I have a roster for a team on a spreadsheet (copies in both excel and google sheets formats). We have a column where we put a checkmark if the member has met conditions or complied with a directive. What I would like to do is have the spreadsheet calculate all instances in the column where there is no checkmark or content. But instead of just displaying the number of people/cells (i've toyed with functions to count blank cells with mixed results) that meet the conditions, I would like it to output the names associated with this status (names in column A, checkmark in column B). Can anyone give me a hand with this? I'm very rusty on my spreadsheets. If this isn't possible as described, can someone explain to me how to format it to be able to achieve this?
Bookmarks