Counting Unique Customer Purchases For Each Purchase Month

[DEW67]

Hi Everyone,

I need a little help with my excel file. I have a list of customer purchases broken down by purchase date and customer. If a customer purchased more than one product at a time, the excel file will show each item purchased under that customer name. What I want to be able to do is for each month, calculate how many times each customer made a purchase. If you take a look at the image, you can see certain customers will show as 2-3 lines for a given purchase date. I only want to count this as a single transaction and not 2-3.

Thanks in advance.

 

[Ezguy4u]

Dew67 can down load and use this XL22B program? Then post your data

XL2BB - Excel Range to BBCode -

 

[mehidy1437]

see, if this okay or not?

how-to-extract-a-unique-list-from-two-columns-in-excel-2007.xlsx
	A	B	C	D	E	F	G
1	CUSTOMER	DATE	COUNT		CUSTOMER	MONTH	COUNT
2	AA	9/26/2020	2		AA	Jun-20	1
3	AA	9/16/2020	2		AA	Jul-20	2
4	AA	9/16/2020	2		AA	Aug-20	2
5	BB	9/16/2020	2		AA	Sep-20	2
6	CC	9/16/2020	1		BB	Jun-20	1
7	AA	8/23/2020	2		BB	Aug-20	1
8	AA	8/22/2020	2		BB	Sep-20	2
9	BB	8/21/2020	1		CC	Nov-19	3
10	CC	8/23/2020	2		CC	Aug-20	2
11	AA	8/23/2020	2		CC	Sep-20	1
12	AA	7/28/2020	2
13	AA	7/21/2020	2
14	BB	6/28/2020	1
15	CC	11/22/2019	3
16	AA	6/28/2020	1
17	AA	9/26/2020	2
18	AA	9/16/2020	2
19	AA	9/16/2020	2
20	BB	9/17/2020	2
21	CC	9/16/2020	1
22	AA	8/23/2020	2
23	AA	8/22/2020	2
24	BB	8/21/2020	1
25	CC	8/23/2020	2
26	AA	8/23/2020	2
27	AA	7/28/2020	2
28	AA	7/21/2020	2
29	BB	6/28/2020	1
30	CC	11/22/2019	3
31	AA	6/28/2020	1
32	AA	9/26/2020	2
33	AA	9/16/2020	2
34	AA	9/16/2020	2
35	BB	9/16/2020	2
36	CC	9/16/2020	1
37	AA	8/23/2020	2
38	AA	8/22/2020	2
39	BB	8/21/2020	1
40	CC	8/29/2020	2
41	AA	8/23/2020	2
42	AA	7/28/2020	2
43	AA	7/21/2020	2
44	BB	6/28/2020	1
45	CC	11/22/2019	3
46	AA	6/28/2020	1
47	CC	11/21/2019	3
48	CC	11/22/2019	3
49	CC	11/23/2019	3
50	CC	11/22/2019	3
Sheet2

Cell Formulas
Range	Formula
C2:C50,G2:G11	G2	=ROUNDUP(SUMPRODUCT(($A$2:$A$50=E2)*(MONTH($B$2:$B$50)=MONTH(F2))*(YEAR($B$2:$B$50)=YEAR(F2))*(1/COUNTIF($B$2:$B$50,$B$2:$B$50))),0)