Simple Multi Row Question

Jeff13

This should be simple question for this group. My data is below. If the current row's ID is the same as the next row's ID, and the Age1 = Y, I need the next rows Age1 field to be a Y. The second set of data below is what I need with the red values getting changed. I tried a few variations with the multi row formula and all have been unsuccessful

Thanks in advance.

ID Age1
30 N
31 N
65 Y
65 N
86 Y
86 N
167 Y
167 N

Here is what I need

ID Age1
30 N
31 N
65 Y
65 Y
86 Y
86 Y
167 Y
167 Y

ShankerV

Hi @Jeff13 

As mentioned by @PhilipMannering , his formula also works.

One more way of doing this as per the logic explained when current row's ID is the same as the next row's ID.

IF [ID]=[Row-1:ID]
THEN "Y"
ELSE [Age1]
ENDIF

Many thanks

Shanker V

Simple Multi Row Question.yxmd