Excel- Add sequential names to column based off of named range but skip names if duplicate name exists in adjacent column
Solution 1:
I was able to find a more elegant answer using the following formula:
=INDEX(Engineers,AGGREGATE(15,6,ROW(Engineers)-1/(Engineers<>Schedule!$D3),MOD((ROWS($1:1)-1),ROWS(Engineers)-1)+1))
I appreciate the help though!