| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filters
I have set up a spreadsheet, and on sheet 2, I have put in formulas to pull
through names etc from sheet 1. This is so i don't have to re-enter them. However, sometimes the details for a person could appear more than once on sheet 1, and i only want to show them once on sheet 2. I have tried things like advanced filters, but it looks at the formulas in the cells and thinks they are unique, so keeps them in. Is there any way of only displaying unique records on sheet 2? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help: Multiple filters with mutually exclusive items | Excel Discussion (Misc queries) | |||
| Req: How to create multiple mutually exclusive filters | Excel Worksheet Functions | |||
| filters logics | Excel Worksheet Functions | |||
| How to aviod reset of Pivot filters when reconnecting to database? | Excel Discussion (Misc queries) | |||
| How can I protect an excel worksheet containing filters? | Excel Discussion (Misc queries) | |||
Linear Mode
