Sure, you could try the pivot way .. Just select the col of student nums,
then create the pivot with that col header placed in both the ROW and DATA
(set to COUNT). The ROW area in the pivot sheet will return the required list
of unique student nums
Success? celebrate it, hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"jc132568" wrote:
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