I have a spreadsheet, and on the first sheet i have various client data. To
avoid having to re-enter some of the data on sheet two, I have entered
formulas to pull it through from sheet 1. It is pulling through, ref number,
name, and a start date. It is likely that some people could appear more than
once, but I only want them to show once on sheet 2. I have tried to use
advanced filter, but it is looking at the formula rather than the result, so
it is not filtering out the repeated data. Is there anything i can do to get
round this, I have to get it finished for next week and i am starting to
panic! Please help!

Thanks

Becks