Hi, Hope someone can help me. In the table below I need to know how many people worked on the same work order per month based on column C “Number”. The result for Jan would be-WO 1111222333 would have 2 people and WO 3333111222 would have 2 people. I’m using Excel 2007 and trying the “CountIf Function” in column A. Thanks in advance and sorry if I posted in the wrong area. </SPAN>
B C D E</SPAN>
<TBODY>
</TBODY>
B C D E</SPAN>
Date</SPAN></SPAN> | Number</SPAN></SPAN> | Name</SPAN></SPAN> | Work Order</SPAN></SPAN> |
Jan-13</SPAN></SPAN> | 111111</SPAN></SPAN> | John, Snow</SPAN></SPAN> | 1111222333</SPAN></SPAN> |
Jan-13</SPAN></SPAN> | 111111</SPAN></SPAN> | John, Snow</SPAN></SPAN> | 1111222333</SPAN></SPAN> |
Jan-13</SPAN></SPAN> | 111111</SPAN></SPAN> | John, Snow</SPAN></SPAN> | 1111222333</SPAN></SPAN> |
Jan-13</SPAN></SPAN> | 111111</SPAN></SPAN> | John, Snow</SPAN></SPAN> | 1111222333</SPAN></SPAN> |
Jan-13</SPAN></SPAN> | 222222</SPAN></SPAN> | Jane, Dowe</SPAN></SPAN> | 3333111222</SPAN></SPAN> |
Jan-13</SPAN></SPAN> | 222222</SPAN></SPAN> | Jane, Dowe</SPAN></SPAN> | 3333111222</SPAN></SPAN> |
Jan-13</SPAN></SPAN> | 222222</SPAN></SPAN> | Jane, Dowe</SPAN></SPAN> | 3333111222</SPAN></SPAN> |
Jan-13</SPAN></SPAN> | 333333</SPAN></SPAN> | Henery, John</SPAN></SPAN> | 1111222333</SPAN></SPAN> |
Jan-13</SPAN></SPAN> | 333333</SPAN></SPAN> | Henery, John</SPAN></SPAN> | 1111222333</SPAN></SPAN> |
Jan-13</SPAN></SPAN> | 333333</SPAN></SPAN> | Henery, John</SPAN></SPAN> | 1111222333</SPAN></SPAN> |
Jan-13</SPAN></SPAN> | 333333</SPAN></SPAN> | Henery, John</SPAN></SPAN> | 1111222333</SPAN></SPAN> |
Jan-13</SPAN></SPAN> | 333333</SPAN></SPAN> | Henery, John</SPAN></SPAN> | 1111222333</SPAN></SPAN> |
Jan-13</SPAN></SPAN> | 333333</SPAN></SPAN> | Henery, John</SPAN></SPAN> | 1111222333</SPAN></SPAN> |
Jan-13</SPAN></SPAN> | 333333</SPAN></SPAN> | Henery, John</SPAN></SPAN> | 1111222333</SPAN></SPAN> |
Jan-13</SPAN></SPAN> | 444444</SPAN></SPAN> | Elvis, Presley</SPAN></SPAN> | 3333111222</SPAN></SPAN> |
Jan-13</SPAN></SPAN> | 444444</SPAN></SPAN> | Elvis, Presley</SPAN></SPAN> | 3333111222</SPAN></SPAN> |
Jan-13</SPAN></SPAN> | 444444</SPAN></SPAN> | Elvis, Presley</SPAN></SPAN> | 3333111222</SPAN></SPAN> |
Feb-13</SPAN></SPAN> | 555555</SPAN></SPAN> | Stephen, Hawking</SPAN></SPAN> | 1111222333</SPAN></SPAN> |
Feb-13</SPAN></SPAN> | 555555</SPAN></SPAN> | Stephen, Hawking</SPAN></SPAN> | 1111222333</SPAN></SPAN> |
Feb-13</SPAN></SPAN> | 555555</SPAN></SPAN> | Stephen, Hawking</SPAN></SPAN> | 1111222333</SPAN></SPAN> |
Feb-13</SPAN></SPAN> | 555555</SPAN></SPAN> | Stephen, Hawking</SPAN></SPAN> | 1111222333</SPAN></SPAN> |
Feb-13</SPAN></SPAN> | 666666</SPAN></SPAN> | Reese, Witherspoon</SPAN></SPAN> | 3333111222</SPAN></SPAN> |
Feb-13</SPAN></SPAN> | 666666</SPAN></SPAN> | Reese, Witherspoon</SPAN></SPAN> | 3333111222</SPAN></SPAN> |
Feb-13</SPAN></SPAN> | 666666</SPAN></SPAN> | Reese, Witherspoon</SPAN></SPAN> | 3333111222</SPAN></SPAN> |
<TBODY>
</TBODY>