| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need value from referenced cell | Excel Worksheet Functions | |||
| The absolute referenced cell does not move when source cell moves | Excel Worksheet Functions | |||
| See where a cell is referenced | New Users to Excel | |||
| How do I double click a cell and jump to cell's referenced cell | Excel Discussion (Misc queries) | |||
| function CELL() to return the formula in the referenced cell | Excel Worksheet Functions | |||
Linear Mode
