Need Help with Multi-Row Formula

mallieteal21

Hello - I'm trying to filter this list to find the employees who have not completed a Bachelors degree. I think I need to use a multi-row formula, but not sure how to write the expression to filter each row as some employees have multiple lines in the data (i.e. one line for Associates, Bachelors, Masters, etc.).

Any help would be greatly appreciated!  

Education Data (01022024).xlsx

CoG

While @alexnajm 's approach is correct, the workflow does not account for a couple factors:

1. You cannot simply filter on whether "Bachelor" is contained in the concatenated list (clever strategy though) because "Bachelors not completed" is one of the values in [Level]
2. You also need to account for whether "Bachelors" is the highest stated level of education, but where Graduated is "N", indicating that that individual never "completed" his "Bachelors" degree.
3. Finally the case where an individual's only associated records contain levels of education above Bachelors (e.g. Masters, PhD, etc.) that would indicate that Bachelor's degree was completed, even though no record explicitly states that this is the case.

Here is another sample that addresses these factors although there is an interesting case that you will need to decide how to handle where an individual has "Bachelors" level education with [Graduated] set to "N" even though a graduation date is listed (my workflow assumes that [Graduated] has higher priority). My workflow assumes that Masters, PhD, and Juris Doctor degree-holders have all completed Bachelors degree, and that no other categories have completed Bachelors degree.

Sample Workflow.yxzp