Analysis to be done on the dataa

I have a data with all the instances when Phone Numbers had the data session for 9 months, So if a phone no had multiple sessions in a day i have all of them in Separate rows.

I need to find no. of days when a particular no. had a session on monthly basis.?

Answers


You can use a countifs formula in excel 2010, assuming I understand the problem correctly.

=COUNTIFS([column of phonenumbers],[Phonenumnber to match],[Date Column],">="&[Startdate of the month],[Date Column],"<"&[Startdate of the next month])

That will return a count of all the calls from a specific phone number during that month.


Need Your Help

SQL: Selecting count of multiple tables

php mysql sql

I don't think this will be too complicated to explain, but certainly complicated to get it working.

should i use asp.net membership system or not?

asp.net asp.net-mvc-2 asp.net-membership

I developing a network that uses membership. I have a couple of stories that i have to implement. and i want to use to entity framework with MVC 2 to build this site. asp.net membership system has ...