-
Help about sorting rows and assigning a new field automatically?
Hi there.
I need a favor. I have an excel file which i use at work. I have lots of customers in there and i sort the customer names and add a new column and give them "ID Numbers" per each (The same names get the same ID's)
So Its ok to do this while the list is small but when the list is more then 100 rows then sometimes errors occur..
Is there a way for me to open a new column and make excel write Customer1, customer2 and so on? just like the example below. (with VB or not)
Thank you very much.
Sabi RAZON
John |
Person1 |
John |
Person1 |
John |
Person1 |
Sally |
Person2 |
Sally |
Person2 |
Andy |
Person3 |
Andy |
Person3 |
Paul |
Person4 |
John |
Person1 |
Sally |
Person2 |
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules