Numbering different products

[Manos]

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.

 

[Jim Cone]

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.

 

[Manos]

No i do not want this
I need to show in line 3 that red is appeared as twice
in line 4 to show that red appeared as third time and show on....

 

[Jim Cone]

That is exactly what it does.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Manos"
wrote in message
No i do not want this
I need to show in line 3 that red is appeared as twice
in line 4 to show that red appeared as third time and show on....

 

[David Biddulph]

That is exactly what the formula Jim provided does.
Are you sure that you are using line numbers corresponding to your data
range, and are you sure that you've got the right combination of absolute
and relative addressing as Jim had?