Can I ask for your help with these,
The sheet named "Data" contain names on Column A. The next column is either left blank or marked with "Done" if a report was made.
How do I combine "Countif" to count for names and the condition to look for blanks based on the names.
End goal is to count the number of blanks per name which will be referenced on sheet "Report".