I want to know when there is a value in the cell, the number of times the value is in a different row and the text that says it.
In the table when there is a value in cell B, I want the number of times it occurs cell A.
So Monday 2 times, Tuesday 1 times and so on
Is this possible?
<colgroup><col width="113" style="mso-width-source:userset;mso-width-alt:4132;width:85pt"><col width="227" style="mso-width-source:userset;mso-width-alt:8301;width:170pt"></colgroup><tbody></tbody>
<tbody>
</tbody>
So
Monday 2
Tuesday 1
In the table when there is a value in cell B, I want the number of times it occurs cell A.
So Monday 2 times, Tuesday 1 times and so on
Is this possible?
<colgroup><col width="113" style="mso-width-source:userset;mso-width-alt:4132;width:85pt"><col width="227" style="mso-width-source:userset;mso-width-alt:8301;width:170pt"></colgroup><tbody></tbody>
Monday | 1 |
Tuesday | |
Monday | 1 |
Tuesday | 1 |
<tbody>
</tbody>
So
Monday 2
Tuesday 1