A
AAA1986
Each entry in my database has a category listed in column A. I would like to
create a column that produces the n for each entry's category.
For example, if column A reads:
blue
red
red
green
green
green
Then column B should read:
1
2
2
3
3
3
Anyone know what formula I can use for this column B?
Thanks in advance.
create a column that produces the n for each entry's category.
For example, if column A reads:
blue
red
red
green
green
green
Then column B should read:
1
2
2
3
3
3
Anyone know what formula I can use for this column B?
Thanks in advance.