With your posted data in B5:B10, use this formula in C5 and fill down...
=COUNTIF($B$5:B5,B5)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)
"Manos"
wrote in message
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.