Hi guys,

This is going to be a stupid question I know, but I cannot seem to figure out what should be (I'm sure) a basic formula.

I have a workbook and in column A is a list of dates certain orders were placed. In column B is the name of the person who took the order, i.e.

A B
1 28/10 John
2 28/10 John
3 28/10 Paul
4 28/10 John
5 28/10 Paul
6 29/10 John
7 29/10 John
8 29/10 Paul and so on...

I need to be able to count the number of times both John and Paul took orders on the particular date so that I have figures like this:

28/10
John 3
Paul 2

29/10
John 2
Paul 1

Etc.

Please help!

Thanks