Numbering different products

  • Thread starter Thread starter Manos
  • Start date Start date
M

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.
 
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.
 
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....
 
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?
 
Back
Top