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?
--
David Biddulph

"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....

"Jim Cone" wrote:

With your posted data in B5:B10, use this formula in C5 and fill down...
=COUNTIF($B$5:B5,B5)

"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.