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?