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 |
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 |
All times are GMT +1. The time now is 03:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com