Hello Excel:ers

I am trying to find a formula which returns a value (True or the value in the cell) first time it appreas in a range, next time the same value apprease the formula should return 0.

Below is an example of how I wish the result should look.
Column G "CUST_NO", should be reflected first time it apprease in columen "FIRST PURCHASE"..

Any suggestions?


Untitled.png