If you are using Excel 2007, it's very simple and fast...

Click in the data table. Go to "Data" on Ribbon, Click on "Remove
Duplicates" in "Data Tools" group. Select the coumns which has the Duplicate
records. Click "OK".

Hope this works. if it did, please click on YES.

--
Sheikh Saadi


"jc132568" wrote:

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