Hello!
I am working on a report that requires showing which personnel worked on a task in a specific week.
I have a list of all employees assigned to a task but they don't all necessarily work on that task every week.
I need to only report those that log time on the task and skip those with zero hours.
I have tried various combinations of LOOKUP and COUNTIF but I can only get it to show blanks where there is a zero instead of skipping that line and moving to the next.
I have at least 54 weeks of future reporting just for this task ahead of me so this would very much simplify my job.
Perhaps the attachment can explain better.
Thank you in advance!
Bookmarks