VBA Scripting.xlsThank you stanleydgromjr I created a sample sheet as this would be quicker than revising the original one. I would like to understand how to take the data on both list insert them into an array and extract only the unique item from that list.