Hi all:
I have this problem. I want to write a formula in award column, so that the
"Y" only appears on the first occurance of when user ID have Y in Data, no
other place after first occurance. How can I do that? Hope you can give me
some advice. Thanks much.

ID Data Award
1 Y Y
1 N
1 Y
1 Y
2 N
2 Y Y
2 Y
2 Y