hum… no… let me explain a little more. It is a loyalty app for merchants. The client types his code in page tablet_app, and he accumulates points (that I call vizits) that can be redeemed at consumer_page).
The merchant has its admin page, where he can created rewards (recompensas), see the client list (clientes) and see all redemptions (resgates).
For the client list, what I am trying to do is to build a list of unique values for the clients. For example, client1 visited the store 5 times and client2 visited twice. Im trying to do a list like this…
client1: 5 visitis
client2: 2 visitis
I was able to build the list of unique clients, but not the count. I trying a different angle and I was getting the list of clients (not unique).
Trying to include the count element in the formula, is giving me (i) the total count for all visits and not for each client or (ii) always 1, that is current cells count.
Could I explain it a little better? Sry, not my mother tongue!
Again, thank you so much for your time.