Hi, I'm writing this from a cellphone so I can't upload the data, but I have a column which has the following values (I will type this in array format, without the curly brackets): Bunk1;Bunk1;Bunk2;Bunk8;Bunk5;Camper;Bunk6;Bunk6;Nurse;Bunk7
I need the maximum value of a bunk, in this case the number 8, returned through a sub or function.
I don't think any values other than the ones starting with bunk will have numbers, such as nurse1, but I need to anticipate that, so the code gets the max of only the bunks.
Keep in mind that bunk10 may exist, so u can't just extract the right-most value. There may be double digits.
Thanks all!
I need the maximum value of a bunk, in this case the number 8, returned through a sub or function.
I don't think any values other than the ones starting with bunk will have numbers, such as nurse1, but I need to anticipate that, so the code gets the max of only the bunks.
Keep in mind that bunk10 may exist, so u can't just extract the right-most value. There may be double digits.
Thanks all!