Hi,

Heres the situation.

In Excel I have:

1st column: Thousands of store numbers.
2nd column: I manually created something called €œMaster Corp ID€�

The Problem:
1st Column has approx. 29,500 store numbers but theyre all not unique. Some
stores can have the same store number because theyre all the same type of
store€¦ i.e Circuit City, Best Buy, also, not all Circuit, Best Buy will not
have the same unique number due to type of store it is/area and et cetera.
In-addition, I also have a ton of mom and pop shops with their unique store
numbers.

What I Need Please:
I need a way to in column 2 to automatically assign numbers for each group
of store numbers so for example:

Store Number Master --- Corp ID
2205 1
2205 1
2205 1
2205 1
3566 2
4523 3
5545 4
5545 4
6001 5
6001 5
6001 5

Can someone please help me?