Filtering Referenced Cell
 

I have a worksheet (sheet2) where the data is referenced from another
sheet(sheet1). I tried to filter for unique records in sheet 2 but it still
shows duplicate records.

Thanks!

Filtering Referenced Cell
 

Maybe there was differences between the cells that were difficult to see???

If you use a formula like:
=a2=a13
(change the addresses to match)

If you see a False, you know that you have a real difference.

UT wrote:

I have a worksheet (sheet2) where the data is referenced from another
sheet(sheet1). I tried to filter for unique records in sheet 2 but it still
shows duplicate records.

Thanks!

--

Dave Peterson