You must first change the formulas on Sheet2 to values.


Gord


On Sat, 17 Mar 2012 13:33:17 -0000, Yunus
wrote:


Hi,

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

How do I now filter, Column A Sheet2, for Unique Records

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