Count unique occurrence based on 2 column conditions

[DevAlex]

Hello,

I have 2 columns. Column A is 4 months (January - April), Column B is Years (2015 - 2020). Each Row has a different month and year, but some month and year combinations might repeat. I want to count the number of unique occurrences of repeating month and year combinations.

For example, if January | 2015 appears 20 times, I want to count this unique occurrence as 1. I want this to repeat for all potential year and month combinations.

Any help is appreciated. Thank you.

 

[AhoyNC]

Try:

Book1
	A	B	C	D
1	Month	Year		Unique Count
2	Jan	2015		10
3	Feb	2015
4	March	2015
5	April	2015
6	Jan	2016
7	Feb	2016
8	March	2016
9	April	2016
10	Jan	2015
11	Feb	2016
12	March	2017
13	April	2018
14	Jan	2016
15	Feb	2016
16	March	2016
17	April	2016
Sheet1

Cell Formulas
Range	Formula
D2	D2	=ROWS(UNIQUE(A2:B17))