Hi,

In a column in Sheet 2, all the values in the cells have been referenced
from Column J in Sheet1!

How do I obtain Unique records in this Column.

I attempted Advanced Filter - Copy to another Location - Unique Records
Only, but this only returns Sheet1!L25