I have an Excel file with **Column A** and **Column B**. Both have people names (**Elizabeth**, **John**, **Michael** and **Robert**).

I need to count each name of Column A and count each name of Column B. And then I need to show each name (**Name** column) with the difference that I counted before (**Difference** column).

In databases it is called *Group By*.

I made this example so it can be easier to explain. It has less than 10 rows but I will use it with a file that has 7000 rows:

[![Example using LibreOffice](https://i.stack.imgur.com/443di.png)](https://i.stack.imgur.com/443di.png)