Hello. How does this formula work for counting unique values? Thanks. =SUM(IF(FREQUENCY(B5:B54848, B5:B54848)>0,1))