Hi everyone

I have a list of statuses.
When the list reaches "complete" for each item I want to display COMPLETE in another cell.
When the list contains mixed statuses I want to display INCOMPLETE in that other cell.

Hopefully the attached sheet explains: status report.xlsx

Thanks,