Hi,

I have this formula in one of my templates.
=SUM(FREQUENCY(MATCH(A6:A999;A6:A999;0);MATCH(A6:A999;A6:A999;0))>0;1)

But some times i dont have data in all the Rows.. then the formula says #N/A and i have to manuel change the formula..
Is there any way that i can make the formula ignore the blancks and just make the calculation on the rows that have data in them?

thanks in adwance...