Formula for Counting Multiple Ranges and Multiple Criteria

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

Hi,

Alternative , but lengthy process when compared to pivot table

Punam

Hi Punam,

Thanks, but I've copied your formula into my S/S and amended the column/row references slightly and all I get is #NAME?

Name error comes if your not typing the function name properly for example

1) In stead of Index inde , Match - match or some thing like that
2) After the changes you have to use Ctrl+Shift+Enter instead of just Enter as it is array function
3) Latest Observation excel version, Iferror function will not work in excel 2003 , i am sorry for that
Punnam