Hi all
I have found a way to list uniques from a long list.
{=INDEX(*datalist*,MATCH(0,COUNTIF($B$1:B2,*datalist*),0))}
It workes fine, but it is very slow. As soon as I get data lists with 50 uniques or so, it starts to take a lot of time for it to list the uniques. does anyone know of a better way?
Best
H
Bookmarks