Hi I have a large dataset involving observations of names in a cell like below.
ABC1AB56AC46AC90
I have another dataset "values" that is made up of doubles, with observations for each of the names listed above.
3x8 doubles3x8 doubles6x8 doubles5x8 doubles
The datasets are specifically ordered so that the third observation in "values" has the third name. I want to give each name a number referring to its position in the original vector. E.g. AC90 is the fourth in the list so everywhere AC90 appears, the number 4 is listed.
Best Answer