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:A65 536)0,1)) to count with.

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

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

If this post helps click Yes
---------------
Jacob Skaria


"Seeker" wrote:

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:A65 536)0,1)) to count with.

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