Filtering Referenced Cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF function and cell /sheet reference 3
keeping format of a referenced cell 4
Copy Sheet #'s, but leave cell reference 3
Referencing a cell's data & format in Excel 2004 for Mac 1
Offset to a referenced cell 2
Named Ranges - Multiple Worksheets 2
Subtotalling Filtered Data Across Sheets 3
Blank Cell Reference, without if statement 4

Back
Top