Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FREQUENCY FUNCTIONS
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use SUM and FREQUENCY functions to count unique items | Excel Discussion (Misc queries) | |||
Use SUM and FREQUENCY functions to count unique items | Excel Discussion (Misc queries) | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
histograms - frequency and relative frequency? | Excel Discussion (Misc queries) | |||
frequency | Excel Discussion (Misc queries) |