Hi there !
I was hoping to get some answers/tips on how to go about the following task:
| CLIENT | DATE | Appearance |
| A | Jan 1 | 1 |
| B | Feb 20 | 1 |
| C | Mar 2 | 1 |
| D | Apr 3 | 1 |
| A | May 8 | 2 |
| A | Jun 4 | 3 |
| B | Jul 25 | 2 |
| A | Jul 28 | ??? |
| C | Aug 21 | ??? |
| D | Oct 1 | ??? |
I have a table of Client Names (A, B, C, D). I have a date when they purchased a product from me.
I am trying to come up with a formula/codethat will give me numbers that I have in "Appearance" column. For instance, Client A's first purchase (Appearance #1) was on Jan 1. Then, Client A came back on May 8 for his second purchase (Appearance #2). On Jul 28, Client A shows up again for his X purchase. I need to find that X. Rudely speaking, if I go from the top of the column (A1) to bottom (A99), I want the number of times I have done transaction with a particular client to show up in my "Appearance" column.
Your help is appreciated.
Thank you
