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 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 1st red
2 blue 1 1st blue
3 red 2 2nd red
4 red 3 3rd red
5 white 1 1st white
6 blue 2 2nd blue

When the order changes I want the spread to adjust accordingly.