Formula for a additional column

Question

Hi,

I want to add an column a Col3 which says invalid if There is not at least 1 Col1 value ending with N for each col2 value.

Col1 Col2Col3 ZB833Valid ZB833Valid ZB833Valid ZB833Valid ZN833Valid SB2030InvalidSB2030InvalidSB2030InvalidSB2030InvalidSB2030InvalidSB2123Valid SB2123Valid SB2123Valid SB2123Valid SN2123Valid SBA014InvalidSBF001InvalidSBF001InvalidSBF001Invalid

patrick_digan · Accepted Answer

@Samals I've attached an example workflow demonstrating how I would attack this problem. I'll edit this post with a multi-row example as well shortly.

EDIT: I've added an alternate solution which essentially just applies the multi-row formula tool both forwards and backwards. It's less tools and easier on the eyes, but I think I would tend to use my original solution more often in practice.  They both provide the same answer.