Extract unique items from array and place in a column.

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):

1. 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))).
2. Take the array produced by the formula above and extract a list of all unique values.
3. 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!!