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
Bookmarks