Hello
I need a helper column that will return a Fail for all if there is one fail per ID or if no fails then all Passes or whatever is in that column C:
ID: Question #: Pass/Fail: New Pass/Fail:
123 1 Pass Fail
123 2 Pass Fail
123 3 Fail Fail
345 1 Pass Pass
345 2 Pass Pass
345 3 Pass Pass
Thank you
Bookmarks