How to formula based on Row-1

[kauser]

Hello, 

how can i get this result in formula tool where row=row-1 then "Y" other wise "N" 

ID	Formula
1A	N
1B	Y
1B	Y
1C	N
1D	N
1E	Y
1E	Y
1F	Y
1F	Y
1G	N
1H	N

[binuacs · Accepted solution]

@kauser one way of doing this

[alexnajm]

We'll need some more information - are you doing this per ID? What is the expected result from this data?

Either way, you can look at the MultiRow Formula tool for anything Row-1:  Multi-Row Formula Tool (alteryx.com)