Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Unique entries
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum unique entries only | Excel Discussion (Misc queries) | |||
Unique Entries | Excel Discussion (Misc queries) | |||
Unique Entries | Excel Discussion (Misc queries) | |||
Unique Entries | Excel Worksheet Functions | |||
Unique Entries | Excel Worksheet Functions |