Numbering different products
I need to number random conditions as they occur in a column. The example
show is in its simplest form.
Column A is a list of colors that are selected randomly. Column B needs to
be the order in which the color code was selected relative to equivalent
colors.
So the first red selected will be Red-1, next red selected will be
Red-2. This will happen to for each color. i.e¦¦¦..
A B
1 red 1 1
2 blue 1 1
3 red 2 2
4 red 3 3
5 white 1 1
6 blue 2 2
When the order changes I want the spread to adjust accordingly.
|