Help me on Formula

I need a formula to do a Loyalty reward like task from below points. Help me to do this   Example: One column has customer name another column has purchased value. Every time a customer purchases,...