Column A include a list of numbers, some are duplicated
Column B include a list of numbers from 1-12 that represent the months
I need to count the unique numbers in column A where the month in column B = 1
Example:
ColumnA ColumnB
123 1
223 2
312 3
412 1
123 1
312 2
123 3
So here for example 123 show up twice when B=1 and 412 once on the same month so the unique count should be = 2