Assign number to groups of same numbers
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?
|