Godders199
Active Member
- Joined
- Mar 2, 2017
- Messages
- 313
- Office Version
- 2013
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.
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.