Hi everyone:

I am trying to automatically assign numbers in to a column based on text in another column.

In one column labeled "product_sort" I want a numerically value associated to another column called "product_name"

Sometimes I have many variations of the "product_name" ... so for example if there was 5 variations of a "product_name" then that same "product_name" would be listed on on 5 rows and would need the same numeric value in the column labeled "product_sort" .. for those 5 rows

I am building a product database and have over 3,000 items so I am trying automate this process.

Let me know if I need to clarify further. I seem to have trouble searching for the answer, let alone explaining it... I might not have the correct terminology.

Thank you in advance!

Andrew Evans
Empire Farrier Supply