datafilteradvanced filter

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jc132568" wrote in message
...
Dear experts,
I have a long list of student numbers (numbers occurring more than once).
I
want to set up a formula which automatically filters for unique entries.
I
used an array formula which I got on this site and it works beautifully
however it does slow down my spreadsheet. Can I filter a range A1:A500
using
database functions or a pivot table? I have read that these possibly
won't
slow the system down so much.
kind regards
Martina