Count how many months sales were made

[Godders199]

Hello, struggling to find where to start on this one... I have a spreadsheet column a is sales persons name, column b is sales date. On sheet 2 is a list of the active sales people.
I need to find for each sales person on sheet2 how many months of the year they made a sale. For example life salesperson A , made 10 sales in January and 2 in March and 1 in May. I need to return the answer 3 in column b on sheet 2

i found code that removes all but the first entry each month for each sales person, but I need to keep all the data.

any help,or links to examples would be appreciated.

 

[ER_Neha]

Hello I hope I understood your question. Kindly provide your feedback

Book2
	A	B	C
1	Sales Person Name	sales date	Sales
2	Anna	01-01-2020	10
3	James	01-02-2020	5
4	John	01-04-2020	10
5	Anna	01-02-2020	5
6	James	01-03-2020	10
7	John	15-04-2020	10
8	Anna	01-02-2020	5
Sheet1

This is the formula as in sheet 2

Book2
	A	B
1	Sales Person Name	Total months of sale
2	Anna	2
3	John	1
4	James	2
5
Sheet2

Cell Formulas
Range	Formula
B2:B4	B2	=COUNT(UNIQUE(IF(Sheet1!$A$2:$A$8=Sheet2!A2,MONTH(Sheet1!$B$2:$B$8))))

 

[Godders199]

Yes you did, thanks alot

 

[ER_Neha]

Yes you did, thanks alot

Thank you for the feedback. Happy to Help