SOLVED

Help with calculations

%3CLINGO-SUB%20id%3D%22lingo-sub-1928718%22%20slang%3D%22en-US%22%3EHelp%20with%20calculations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1928718%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%20!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20hoping%20to%20get%20some%20answers%2Ftips%20on%20how%20to%20go%20about%20the%20following%20task%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22290%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2268%22%3ECLIENT%3C%2FTD%3E%3CTD%20width%3D%2278%22%3EDATE%3C%2FTD%3E%3CTD%20width%3D%22144%22%3EAppearance%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EA%3C%2FTD%3E%3CTD%3EJan%201%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3EFeb%2020%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3EMar%202%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ED%3C%2FTD%3E%3CTD%3EApr%203%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EA%3C%2FTD%3E%3CTD%3EMay%208%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EA%3C%2FTD%3E%3CTD%3EJun%204%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3EJul%2025%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EA%3C%2FTD%3E%3CTD%3EJul%2028%3C%2FTD%3E%3CTD%3E%3F%3F%3F%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3EAug%2021%3C%2FTD%3E%3CTD%3E%3F%3F%3F%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ED%3C%2FTD%3E%3CTD%3EOct%201%3C%2FTD%3E%3CTD%3E%3F%3F%3F%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20table%20of%20Client%20Names%20(A%2C%20B%2C%20C%2C%20D).%20I%20have%20a%20date%20when%20they%20purchased%20a%20product%20from%20me.%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20come%20up%20with%20a%20formula%2Fcodethat%20will%20give%20me%20numbers%20that%20I%20have%20in%20%22Appearance%22%20column.%20For%20instance%2C%20Client%20A's%20first%20purchase%20(Appearance%20%231)%20was%20on%20Jan%201.%20Then%2C%20Client%20A%20came%20back%20on%20May%208%20for%20his%20second%20purchase%20(Appearance%20%232).%26nbsp%3B%20On%20Jul%2028%2C%20Client%20A%20shows%20up%20again%20for%20his%20X%20purchase.%20I%20need%20to%20find%20that%20X.%20Rudely%20speaking%2C%20if%20I%20go%20from%20the%20top%20of%20the%20column%20(A1)%20to%20bottom%20(A99)%2C%20I%20want%20the%20number%20of%20times%20I%20have%20done%20transaction%20with%20a%20particular%20client%20to%20show%20up%20in%20my%20%22Appearance%22%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20help%20is%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1928718%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1928771%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20calculations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1928771%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F880607%22%20target%3D%22_blank%22%3E%40seyranmammadov%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEnter%20the%20following%20formula%20in%20C2%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DCOUNTIF(A%242%3AA2%2CA2)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFill%20down%20to%20the%20end%20of%20the%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi there !

 

I was hoping to get some answers/tips on how to go about the following task:

 

CLIENTDATEAppearance
AJan 11
BFeb 201
CMar 21
DApr 31
AMay 82
AJun 43
BJul 252
AJul 28???
CAug 21???
DOct 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

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

@seyranmammadov 

Enter the following formula in C2:

 

=COUNTIF(A$2:A2,A2)

 

Fill down to the end of the data.

@Hans Vogelaar Thank you and God Bless!