Unique Records in Column

[Yunus]

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

 

[Gord Dibben]

You must first change the formulas on Sheet2 to values.


Gord

 

[Yunus]

You must first change the formulas on Sheet2 to values.


Gord

Thanks Gord,

That's what I suspected, so it's Copy/Paste special/Values in another
Column in Sheet 2?

 

[Gord Dibben]

Yes.

Or just copy and paste special values in the same column in Sheet2 but
that may be inconvenient or undesirable.


Gord