Hello everyone. New user here.
I have been doing quite a bit of research and have found many supposed VBA module codes that should work but I can not get them to work for the life of me.
Here is a brief rundown of what I am attempting to do (I currently need help with step 2):
- Take a string separated with commas and extract each value to its own cell. I accomplished this with the following formula =TRIM(MID(SUBSTITUTE('MEAL CABLE SCHEDULE'!$L2,",",REPT(" ",LEN('MEAL CABLE SCHEDULE'!$L2))),(1-1)*LEN('MEAL CABLE SCHEDULE'!$L2)+1,LEN('MEAL CABLE SCHEDULE'!$L2))).
- Take the array produced by the formula above and extract a list of all unique values.
- Eventually take the list of unique values and use them to back reference other values from the spreadsheet.
I have attempted to use ideas from the following link but apparently i cant post a link yet so I guess you have to use your imagination....
Can anyone help? Thanks in advance!!
Bookmarks