Hi All,

I have a dataset which has a list of clients that I am trying to find the unique records, based on a second column saying N, R, MTA or MTC, and a third column saying H or T. I have been able to do that within a formula as below, but the formula takes about 15 minutes to run on 1 cell, i have it on 4. As well as a variation on another 4 cells, is this something that can be done with VBA?

=SUM(--(FREQUENCY(IF(Daybook!U:U<>"",IF(Daybook!AL:AL=$A4,MATCH(Daybook!U:U,Daybook!U:U,0))),ROW(Daybook!U:U)-ROW(Daybook!U2)+1)>0))

Thank you
Dustin