FREQUENCY FUNCTIONS

  • Thread starter Thread starter ChristopherDreammaker
  • Start date 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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multi-demensional frequency distribution 4
Frequency function 2
Excel VBA 1
count frequency of a word in range of cells 2
Small,Frequency question 1
Frequency vs Count 10
frequency 1
Beginer's problemBeginner's problem 6

Back
Top