SOLVED

New Contributor

# Help with calculations

Hi there !

 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.

Thank you

2 Replies
Best Response confirmed by seyranmammadov (New Contributor)
Solution

# Re: Help with calculations

Enter the following formula in C2:

=COUNTIF(A\$2:A2,A2)

Fill down to the end of the data.

# Re: Help with calculations

@Hans Vogelaar Thank you and God Bless!