Given the list of values 1,2,3,4,1,2,5, an Excel Data>Advanced Filter>Unique Records Only will return a filtered list of 1,2,3,4,5. But 1 and 2 are clearly not unique!

In fact this is often the result we want but still that check box should say, “List unique records and none unique records only once” (or something!)

Further it’s a bit of a pain to do a pivot table of a filter all the time so why has Excel not got a function to do this!!! =countunique(range)!

Well ExcelTip.com offers a solution here in the form of a UDF, which is quite fast and work just like the advance filter does. Handy.

For a truly unique experience though, you’ll have to visit here, be warned it’s a slow old dog and if you intend to use it a lot you need to write a C++ function really.

Does anyone know other FUNCTIONS that will get this job done?

PS, don’t forget to check out Ron de Bruin’s Easy Filter Addin an excellent tool!