Format Error
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.
|