Hereâ€™s the situation.
In Excel I have:
1st column: Thousands of store numbers.
2nd column: I manually created something called â€śMaster Corp IDâ€ť
1st Column has approx. 29,500 store numbers but theyâ€™re all not unique. Some
stores can have the same store number because theyâ€™re 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
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
Can someone please help me?