I'm using this formula: =SUM(IF(FREQUENCY(A1:A200,A1:AD200)>0,1)) to count unique numbers in column A.
I noticed that if a letter(s) proceed numbers it does not count. I'm assuming this is correct for this function.
Is there a way to modify the formula to count unique "cells" if either numbers or letters? or another solution all together.