Format Error

[Seeker]

I have a formula in a cell which output will be appended to another column, I
used copy -> past special -> value. The figure of value in the new cell now
become text.

Some of these copied numbers are duplicated, I need to count the unique
occurency of the number value and do some calculation with these numbers.

I have done a small macro to do the copy & paste, so I need another small
macro embed to the current one in turning the text value back into number
value, so that I can use
=SUM(IF(FREQUENCY(Records!A2:A65536,Records!A2:A65536)>0,1)) to count with.

Any way I can do it please, thanks in advance.

 

[Jacob Skaria]

You may use the CountIF function to get the count of of a particular entry.

If this post helps click Yes