Forum Discussion
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, the amount should be entered on the purchase value.
In another column these total purchases were added.
My question is to I need to set a point like system, whenever a customer has purchased a value of amount a reward point like value is added together on another column.
Like every 1 spent 1 reward value . How to create this kind of formula in sheet?
=COUNTIF($A$2:A2,A2)You can try COUNTIF for the reward points. The formula can be filled down as required.
