Hi there, formula =arrayformula(if(and(MAX(IF($B:$B=$B212,$A:$A))=VALUE($A212),MAX(($B:$B=$B212)*($A:$A=$A212)row($A:$A))=row()),“Y”,“N”))
is in a google sheet.
Appsheet has got this as
However when new entries are made in the app, the formula does not copy down, and the cell remains blank.
Can anyone recommend any suggestions here? Thanks in advance