Compare and count two columns

Closed
jlbweb Posts 2 Registration date Monday March 4, 2013 Status Member Last seen March 5, 2013 - Mar 4, 2013 at 07:27 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Mar 5, 2013 at 11:57 AM
Hello,

I am struggling with a fairly basic excely problem.

I have 2 colums Feb 2012 and Feb 2013 each have a number of different crime types in them.
I would like a table showing a count of the number of each crime type for each month.

Eg
.................F2012.......F2013
Assault.........3................0
Burglary........2................4
Theft...........0................2
Robbery........1................5
Drugs...........0................3

I can manage a pivot table for each column but I cant get a side by side comparison.

Any help appreciated.

Jon

3 replies

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Mar 4, 2013 at 02:05 PM
Hi Jon,

If I am correct, you have provided the final format of the table? I can design the same for you, request you to kindly provide the raw data from which you want to make this table.

Please do write back to us.
0
jlbweb Posts 2 Registration date Monday March 4, 2013 Status Member Last seen March 5, 2013
Mar 5, 2013 at 05:58 AM
So my original data looks a bit like this:

2012........2013
Theft.....Burglary
Theft.....Robbery
Drugs.....Theft
Assault...Drugs
Robbery...Robbery


Etc... there are a few hundred rows though.

Thanks in anticipation
0
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Mar 5, 2013 at 11:57 AM
Hi Jon,

Thank you for providing the Raw Data format. I have created your desired table using COUNTIFS() Worksheet Function of Microsoft Excel. I have uploaded the sample file here:

http://speedy.sh/UVeHd/COUNTIFS.xlsx

Please revert for clarification.
0