hello,

Is there a way to have a macro code to copy an array start from column B47 to the last B row has the data and paste unique value to column O24 to O41? If there is a formula for it, that would be awesome as well.

Thanks