I have two columns. Column A contains first and last names. Column B is the category of the job. A person will have completed jobs in different categories and in the same category; and so their name will show up more than once in column A.
I want to be able to query the job category and then show how many times the person is in that category.
Say, John Smith is in column A twice and both categories for him are MOWING. I want to query it and then format the result to show: