In other words, I have thousands of names repeated, each instance of that name has an application tied to it plus a status of whether that application failed or passed. I need to make one status for each person that gives an overall view. If the person is tied to 3 apps that have failed and 3 apps that have passed I would like the overall status to indicate "Not Complete." @jackcherry
I think this comes close, however, what if the wording is changed slightly. @Sergei Baklan
So instead of Pass, Fail, its either Planning, In Progress , or Complete. I am still looking for the same result: if one cell associate with one name is "In Progress" or "Planning" the overall status would be "Not Complete."
I am assuming the wording wouldn't matter, but it appears that it does.