Pivot-sample.xlsx

<div>
<div class="content wysiwyg-content">
I have two columns. &nbsp;Column A contains first and last names. &nbsp;Column B is the category of the job. &nbsp;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.<br />
<br />
I want to be able to query the job category and then show how many times the person is in that category.<br />
<br />
Say, John Smith is in column A twice and both categories for him are MOWING. &nbsp;I want to query it and then format the result to show:<br />
<br />
John Smith 2
</div>
</div>


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:

John Smith 2

Excel question

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.