I am trying to ensure that there is only one entry per day per area.
Column A is the date of entry.
The areas are a list "Anodizing", "Tumbling", "Cleaning", and "Passivation". Which are entered into Column B.
I could pretty easily use a macro to do this, but if I can just use a conditional format or possible data validation to do this it would be preferred as the sheet currently is not macro based.
<colgroup><col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:4278;width:88pt" width="117"> </colgroup><tbody>
</tbody>
I am having a brain fart on finding a solution for this any help would be greatly appreciated.
Column A is the date of entry.
The areas are a list "Anodizing", "Tumbling", "Cleaning", and "Passivation". Which are entered into Column B.
I could pretty easily use a macro to do this, but if I can just use a conditional format or possible data validation to do this it would be preferred as the sheet currently is not macro based.
Date | Area |
11/1/2018 | Anodizing |
11/1/2018 | Tumbling |
11/1/2018 | Cleaning |
11/1/2018 | Cleaning |
10/31/2018 | Anodizing |
10/31/2018 | Tumbling |
10/31/2018 | Cleaning |
10/31/2018 | Passivation |
10/31/2018 | Anodizing |
<colgroup><col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:4278;width:88pt" width="117"> </colgroup><tbody>
</tbody>
I am having a brain fart on finding a solution for this any help would be greatly appreciated.