View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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