Im having trouble figuring out how to count unique values using three sets of criteria. for example:
<tbody>
</tbody>
<colgroup><col width="110" style="width:83pt"> <col width="110" style="width:83pt"> <col width="110" style="width:83pt"> </colgroup><tbody>
</tbody>
<tbody>
</tbody>
<colgroup><col width="110" style="width:83pt"> <col width="110" style="width:83pt"> <col width="110" style="width:83pt"> </colgroup><tbody>
</tbody>
All the above data is on sheet one and I want to display the results on sheet 2. I need to know how many unique row records there are for each job_no.
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
I would like to have the table look like this when it is all done. Any help would be greatly appreciated.
employee_id | job_no | union_id |
<tbody>
</tbody>
STE58 | 110080 | NYPLA |
STE58 | 110080 | NYPLA |
HAN56 | 110082 | NYPLA |
STE58 | 110082 | NYPLA |
JEF27 | 110082 | LITA |
HAN56 | 110082 | NYPLA |
HAN56 | 110082 | NYPLA |
<colgroup><col width="110" style="width:83pt"> <col width="110" style="width:83pt"> <col width="110" style="width:83pt"> </colgroup><tbody>
</tbody>
BRI80 | 110082 | NYTA |
<tbody>
</tbody>
STE35 | 120260 | LICA |
SCH72 | 120260 | LICA |
<colgroup><col width="110" style="width:83pt"> <col width="110" style="width:83pt"> <col width="110" style="width:83pt"> </colgroup><tbody>
</tbody>
All the above data is on sheet one and I want to display the results on sheet 2. I need to know how many unique row records there are for each job_no.
Job_no | NYPLA | LITA | NYTA | LICA |
110080 | 1 | 0 | 0 | 0 |
110082 | 2 | 1 | 1 | 0 |
120260 | 0 | 0 | 0 | 1 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
I would like to have the table look like this when it is all done. Any help would be greatly appreciated.