How many followup made by a salesman between a particular set of dates

[roshanakhtar]

I am trying to analyse, in a set of data that how many followup made by a salesman between a particular set of dates. I've attached a sample. In this example I differentiate between people if the name and age are same. I know that it is possible with formula 'countifs' but how? Please help me.

[greggpetersen75]

If you use the concatenate function for the name and the age it will give you the unique key figure you desire.

[Tony Valko]

Is this a duplicate thread:

http://www.excelforum.com/excel-form...-of-dates.html

[Fotis1991]

Thanks Tony.

Unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.