Counting same text across multiple columns

Hi all

I need to count the number of times the same text occurs in 2 columns (in a single row) and put the number in a separate column. In case I haven't explained myself well (which I haven't), here is an example.


Customer Date of report Data
1 12/11/2012 Data 1
1 12/11/2012 Data 2
1 12/11/2012 Data 3
1 12/11/2012 Data 4
2 13/11/2012 Data 5
2 13/11/2012 Data 6
2 13/11/2012 Data 7
2 14/11/2012 Data 9
3 15/11/2012 Data 10
3 16/11/2012 Data 11
3 17/11/2012 Data 12

So I want to know how many times Customer 1 has put in a report on the 12th of November 2012 (with that figure being displayed in another column that I can sort and filter on).

I have kind of worked it out by concatenating the two columns but that isn't going to give me exactly what I want.

Happy to be told what to do...


Louise

Hi Moo

Thanks for getting back to me so quickly, this works well. What I really want is for the command to automatically review all of column A and B, calculate the number of occurences and then display the figure for each row - I know that I will get multiple rows for each customer (with the same number of occurences displayed) but that is OK as the data will be different and I can sort/filter.

I don't want to input figures as this is a big spreadshest.

Thanks again,


Louise

OK, well, if you put this formula in cell D2 in my spreadsheet above, then fill down, I think it does what you want. Let me know:

Formula:

Please Login or Register  to view this content.

-Moo

Dearest Moo (aka life saver).

Thank you ....... If you ever come to the wonderful land of Australia, I owe you a drink (top shelf).


Louise

You're very welcome.

Aww shucks.. now I'm blushing.

- Moo

And I am smiling !!!!!!

Thanks again, really appreciate it.