FREQUENCY FUNCTIONS
When you use the ampersand to meerge 2 values they become text, if you for
instance use
=A1&B1
change to
=--(A1&B1)
to make that a number assuming that A1 and B1 hold nuymbers
--
Regards,
Peo Sjoblom
"ChristopherDreammaker"
wrote in message ...
I'm using excel 2003.
When i join the content of two cell, using the & formula, i want to
perform
a frequency function on the new cell, but it gives back a result of 0,
although if i type the data of the two cells into one manually and perform
the task it works fine. Any ideas on what i can do so it will recognise
the
data in the new cell
|