FREQUENCY FUNCTIONS

  • Thread starter ChristopherDreammaker
  • Start date
C

ChristopherDreammaker

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
 
P

Peo Sjoblom

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
 
Top