Limit occurences of text in a range of cells
I am trying to work out an assignment worksheet. This is how it will be set up:
Column A would be a list of employee names.
Column B would be where assignments are placed.
The assignments are: A, B, C, D, E, F, G, H, J, K, L, M, RDO, Ill, Vacation, Comp., Jury
What I want the VBA code to do is limit the assignments A through M to only two occurrences for the list.
Maybe this wouldn't take VBA at all, maybe it could be done with formulas. I don't know.
Thanks in advance for your help.