Formula for a additional column

[Samals]

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	Col2	Col3
ZB	833	Valid
ZB	833	Valid
ZB	833	Valid
ZB	833	Valid
ZN	833	Valid
SB	2030	Invalid
SB	2030	Invalid
SB	2030	Invalid
SB	2030	Invalid
SB	2030	Invalid
SB	2123	Valid
SB	2123	Valid
SB	2123	Valid
SB	2123	Valid
SN	2123	Valid
SB	A014	Invalid
SB	F001	Invalid
SB	F001	Invalid
SB	F001	Invalid

[patrick_digan · Accepted solution]

@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.

[Jim7]

Here's another solution, if you want to keep the original order you can just add a Record ID tool at the beginning and resort by Record ID.